{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Total Rev Rec","EPS","Corp OH","EPC Rev Recog","FS","TS","O&M Rev Recg","PS PES","PRS ","FS CON Rev Rec","FS PES","FS PESI Rev Rec","PES TS Rev Rec","PESI TS Rev Rec","PESI O&M Rev Recog","International O&M Rev Recog"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Total Rev Rec","index":0,"n_rows":100,"n_cols":26,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin",null,"Net Margin","Cash Received to Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["DERWICK001","410-3280","Curupao (2 7F 2 LM6000) (CVG-C","100001",180000000,162000000,2880000,2590972.83,0,2880000,0,{"$f":"G2-H2","v":289027.16999999993},{"$f":"VLOOKUP(B2,[1]Projects!$B:$L,11,0)","v":"I"},{"$f":"G2-H2","v":289027.16999999993},0,{"$f":"+G2-Y2","v":1512000},{"$f":"+H2-Z2","v":1363557.6500000001},{"$f":"H2/F2","v":1.5993659444444443E-2},{"$f":"G2/E2","v":1.6E-2},{"$f":"IF(K2>G2,K2-G2,0)","v":0},{"$f":"IF(G2>K2,G2-K2,0)","v":2880000},{"$f":"+R2-S2","v":-6.3405555555569315E-6},{"$f":"I2-T2","v":0},{"$f":"J2-U2","v":0},1368000,1227415.18]
["DERWICK001","410-3203","CVG Sidor Facility Plant B","100001",79400000,71460000,12362580,11122935.1,27337420,0,39700000,{"$f":"G3-H3","v":1239644.9000000004},{"$f":"VLOOKUP(B3,[1]Projects!$B:$L,11,0)","v":"I"},{"$f":"G3-H3","v":1239644.9000000004},23820000,{"$f":"+G3-Y3","v":5327740},{"$f":"+H3-Z3","v":4793940.3599999994},{"$f":"H3/F3","v":0.15565260425412819},{"$f":"G3/E3","v":0.15570000000000001},{"$f":"IF(K3>G3,K3-G3,0)","v":27337420},{"$f":"IF(G3>K3,G3-K3,0)","v":0},{"$f":"+R3-S3","v":-4.7395745871814388E-5},{"$f":"I3-T3","v":0},{"$f":"J3-U3","v":0},7034840,6328994.7400000002]
["DERWICK001","410-3202","CVG Sidor Facility Plant A","100001",60177913,53923500,17385399.07,15580072.43,33805263.93,0,51190663,{"$f":"G4-H4","v":1805326.6400000006},{"$f":"VLOOKUP(B4,[1]Projects!$B:$L,11,0)","v":"I"},1805326.6400000006,17974500,{"$f":"+G4-Y4","v":5000968.57},{"$f":"+H4-Z4","v":4433886.75},{"$f":"H4/F4","v":0.2889291761476907},{"$f":"G4/E4","v":0.28890000007145478},{"$f":"IF(K4>G4,K4-G4,0)","v":33805263.93},{"$f":"IF(G4>K4,G4-K4,0)","v":0},{"$f":"+R4-S4","v":2.9176076235926107E-5},{"$f":"I4-T4","v":0},{"$f":"J4-U4","v":0},12384430.5,11146185.68]
["CORPO001","10-T9002","Termozulia IV",107002,51800000,46620000,16565640,14910369.390000001,{"$f":"K5-G5","v":22284360},0,38850000,{"$f":"G5-H5","v":1655270.6099999994},{"$f":"VLOOKUP(B5,[1]Projects!$B:$L,11,0)","v":"I"},1655270.6099999994,35172000,3227140,2905017.73,{"$f":"H5/F5","v":0.31982774324324326},{"$f":"G5/E5","v":0.31979999999999997},{"$f":"K5-G5","v":22284360},0,0,0,0,2030560,1826884.67]
["DERWICK001","10-T1004","Jusepin-EPC (4) RR Trent 60","100001",44347000,39912300,1223977.2,1100006.6200000001,0,1223977.2,{"$f":"22173500-22173500","v":0},{"$f":"G6-H6","v":123970.57999999984},{"$f":"VLOOKUP(B6,[1]Projects!$B:$L,11,0)","v":"I"},123970.57999999984,0,{"$f":"+G6-Y6","v":368803.23},{"$f":"+H6-Z6","v":330783.25000000012},{"$f":"H6/F6","v":2.7560592098175251E-2},{"$f":"G6/E6","v":2.76E-2},{"$f":"IF(K6>G6,K6-G6,0)","v":0},{"$f":"IF(G6>K6,G6-K6,0)","v":1223977.2},{"$f":"+R6-S6","v":-3.9407901824748542E-5},{"$f":"I6-T6","v":0},{"$f":"J6-U6","v":0},855173.97,769223.37]
["GENATL001","EQU08-1222","Equip Sales Agreement - CC","104002",37200000,30000000,37200000,30000000,0,0,37200000,{"$f":"+G7-H7","v":7200000},{"$f":"VLOOKUP(B7,[1]Projects!$B:$L,11,0)","v":"I"},7200000,37107637.909999996,{"$f":"+G7-Y7","v":0},{"$f":"+H7-Z7","v":0},{"$f":"+H7/F7","v":1},{"$f":"+G7/E7","v":1},{"$f":"IF(K7>G7,K7-G7,0)","v":0},{"$f":"IF(G7>K7,G7-K7,0)","v":0},{"$f":"+R7-S7","v":0},{"$f":"+I7-T7","v":0},{"$f":"+J7-U7","v":0},37200000,30000000]
["EDC001","10-T1009","Guarenas I","100001",36340516.649999999,32706465,6065232.2300000004,5459128.8499999996,8470974.4199999999,0,14536206.65,{"$f":"G8-H8","v":606103.38000000082},{"$f":"VLOOKUP(B8,[1]Projects!$B:$L,11,0)","v":"I"},606103.38000000082,0,{"$f":"+G8-Y8","v":3274280.5500000003},{"$f":"+H8-Z8","v":2948215.3799999994},{"$f":"H8/F8","v":0.16691283665171394},{"$f":"G8/E8","v":0.16690000003068203},{"$f":"IF(K8>G8,K8-G8,0)","v":8470974.4199999999},{"$f":"IF(G8>K8,G8-K8,0)","v":0},{"$f":"+R8-S8","v":1.2836621031908635E-5},{"$f":"I8-T8","v":0},{"$f":"J8-U8","v":0},2790951.68,2510913.4700000002]
["DERWICK001","10-T9036","LaRaisa II (2 LM6000)","100001",33609000,27000000,414000,373585.49,0,414000,{"$f":"16804500-16804500","v":0},{"$f":"G9-H9","v":40414.510000000009},{"$f":"VLOOKUP(B9,[1]Projects!$B:$L,11,0)","v":"I"},40414.510000000009,0,{"$f":"+G9-Y9","v":225000},{"$f":"+H9-Z9","v":203076.22999999998},{"$f":"H9/F9","v":1.383649962962963E-2},{"$f":"G9/E9","v":1.2318129072569847E-2},{"$f":"IF(K9>G9,K9-G9,0)","v":0},{"$f":"IF(G9>K9,G9-K9,0)","v":414000},{"$f":"+R9-S9","v":1.5183705570597835E-3},{"$f":"I9-T9","v":0},{"$f":"J9-U9","v":0},189000,170509.26]
["EDC001","10-T9018","La Raisa (3) FT8","100001",33491875,30142687.5,12358501.880000001,11123846.369999999,21133373.120000001,0,33491875,{"$f":"+G10-H10","v":1234655.5100000016},{"$f":"VLOOKUP(B10,[1]Projects!$B:$L,11,0)","v":"I"},1234655.5100000016,18781824.600000001,{"$f":"+G10-Y10","v":2836761.8200000003},{"$f":"+H10-Z10","v":2555483.59},{"$f":"+H10/F10","v":0.36903963423964764},{"$f":"+G10/E10","v":0.36900000014928996},{"$f":"IF(K10>G10,K10-G10,0)","v":21133373.119999997},{"$f":"IF(G10>K10,G10-K10,0)","v":0},{"$f":"+R10-S10","v":3.9634090357676399E-5},{"$f":"+I10-T10","v":0},{"$f":"+J10-U10","v":0},9521740.0600000005,8568362.7799999993]
["DERWICK001","10-T1003","Barinas (La Fria) (2FT-4TP)","100001",30000000,27000000,1254.0999999999999,1140.0899999999999,0,1254.0999999999999,0,{"$f":"+G11-H11","v":114.00999999999999},{"$f":"VLOOKUP(B11,[1]Projects!$B:$L,11,0)","v":"I"},114.00999999999999,0,{"$f":"+G11-Y11","v":1254.0999999999999},{"$f":"+H11-Z11","v":1140.0899999999999},{"$f":"H11/F11","v":4.2225555555555555E-5},{"$f":"G11/E11","v":4.1803333333333333E-5},{"$f":"IF(K11>G11,K11-G11,0)","v":0},{"$f":"IF(G11>K11,G11-K11,0)","v":1254.0999999999999},{"$f":"+R11-S11","v":4.2222222222222194E-7},{"$f":"I11-T11","v":0},{"$f":"J11-U11","v":0},0,0]
["EDC001","10-T9003B","Planta Picure/Tacoa B (2) LM6000s","100001",20774500,18697050,10586685.199999999,9527993.1300000008,10187814.800000001,0,20774500,{"$f":"+G12-H12","v":1058692.0699999984},{"$f":"VLOOKUP(B12,[1]Projects!$B:$L,11,0)","v":"I"},1058692.0699999984,19949000,{"$f":"+G12-Y12","v":1988119.6499999985},{"$f":"+H12-Z12","v":1788914.1400000006},{"$f":"+H12/F12","v":0.50959874044301112},{"$f":"+G12/E12","v":0.50959999999999994},{"$f":"IF(K12>G12,K12-G12,0)","v":10187814.800000001},{"$f":"IF(G12>K12,G12-K12,0)","v":0},{"$f":"+R12-S12","v":-1.2595569888196323E-6},{"$f":"+I12-T12","v":0},{"$f":"+J12-U12","v":0},8598565.5500000007,7739078.9900000002]
["PACIFICRIM002","FS07-0344CABR-1","Cabrutica Installation","804002",17000000,15300000,2834802.62,1981774.53,7340197.3799999999,0,10175000,{"$f":"+G13-H13","v":853028.09000000008},{"$f":"VLOOKUP(B13,[1]Projects!$B:$L,11,0)","v":"I"},853028.09000000008,6475000,{"$f":"+G13-Y13","v":-100000},{"$f":"+H13-Z13","v":197690.12000000011},{"$f":"+H13/F13","v":0.12952774705882353},{"$f":"+G13/E13","v":0.16675309529411766},{"$f":"IF(K13>G13,K13-G13,0)","v":7340197.3799999999},{"$f":"IF(G13>K13,G13-K13,0)","v":0},{"$f":"+R13-S13","v":-3.7225348235294137E-2},{"$f":"+I13-T13","v":0},{"$f":"+J13-U13","v":0},2934802.62,1784084.41]
["EDC001","10-T9003A","Planta Picure/Tacoa A (2) LM2500s","100001",14914408.5,13422967.65,10801014.640000001,9720835.8399999999,4113393.86,0,14914408.5,{"$f":"+G14-H14","v":1080178.8000000007},{"$f":"VLOOKUP(B14,[1]Projects!$B:$L,11,0)","v":"I"},1080178.8000000007,12536000,{"$f":"+G14-Y14","v":2392271.1300000008},{"$f":"+H14-Z14","v":2153265.41},{"$f":"+H14/F14","v":0.72419423882020606},{"$f":"+G14/E14","v":0.72420000028831188},{"$f":"IF(K14>G14,K14-G14,0)","v":4113393.8599999994},{"$f":"IF(G14>K14,G14-K14,0)","v":0},{"$f":"+R14-S14","v":-5.7614681058248962E-6},{"$f":"+I14-T14","v":0},{"$f":"+J14-U14","v":0},8408743.5099999998,7567570.4299999997]
["DERWICK001","409-2956-1","Margarita Island Dual Fuel","104002",11263966,10137569.4,251186.44,225738.73,0,251186.44,0,{"$f":"+G15-H15","v":25447.709999999992},{"$f":"VLOOKUP(B15,[1]Projects!$B:$L,11,0)","v":"I"},25447.709999999992,0,{"$f":"+G15-Y15","v":157695.52000000002},{"$f":"+H15-Z15","v":141374.1},{"$f":"+H15/F15","v":2.2267539791145596E-2},{"$f":"+G15/E15","v":2.2299999840198381E-2},{"$f":"IF(K15>G15,K15-G15,0)","v":0},{"$f":"IF(G15>K15,G15-K15,0)","v":251186.44},{"$f":"+R15-S15","v":-3.2460049052784185E-5},{"$f":"+I15-T15","v":0},{"$f":"+J15-U15","v":0},93490.92,84364.63]
["DERWICK001","10-T1006","Las Morochas (1) GE LM2500","100001",7975000,7177500,855717.5,770389.54,0,855717.5,{"$f":"4785000-3987500-797500","v":0},{"$f":"G16-H16","v":85327.959999999963},{"$f":"VLOOKUP(B16,[1]Projects!$B:$L,11,0)","v":"I"},85327.959999999963,0,{"$f":"+G16-Y16","v":540705},{"$f":"+H16-Z16","v":486941.63000000006},{"$f":"H16/F16","v":0.10733396586555208},{"$f":"G16/E16","v":0.10730000000000001},{"$f":"IF(K16>G16,K16-G16,0)","v":0},{"$f":"IF(G16>K16,G16-K16,0)","v":855717.5},{"$f":"+R16-S16","v":3.3965865552071373E-5},{"$f":"I16-T16","v":0},{"$f":"J16-U16","v":0},315012.5,283447.90999999997]
["DERWICK001","710-3347","CVG 2 Shipping",107002,6693000,6084545.46,2182587.2999999998,1984217.18,0,2182587.2999999998,0,{"$f":"G17-H17","v":198370.11999999988},{"$f":"VLOOKUP(B17,[1]Projects!$B:$L,11,0)","v":"I"},198370.11999999988,0,16742.5,15397.35,{"$f":"H17/F17","v":0.32610770895612634},{"$f":"G17/E17","v":0.32609999999999995},0,2182587.2999999998,0,0,0,2165854.7999999998,1968819.83]
["DERWICK001","710-3150","CVG Shipping",107002,5724950,5204500.5199999996,4806668.0199999996,4369682.5199999996,{"$f":"K18-G18","v":918281.98000000045},0,5724950,{"$f":"G18-H18","v":436985.5},{"$f":"VLOOKUP(B18,[1]Projects!$B:$L,11,0)","v":"I"},436985.5,5724950,572.49,520.44000000000005,{"$f":"H18/F18","v":0.83959690333550008},{"$f":"G18/E18","v":0.8395999999999999},{"$f":"K18-G18","v":918281.98000000045},0,0,0,0,59539.48,54103.35]
["NATCONTR001","FS08-1678 REV 1","Nat Ctr Aviation - Wichita","104013",5220525,4926101.08,5180332.26,4926101.08,0,390920.07,4789412.1900000004,{"$f":"+G19-H19","v":254231.1799999997},{"$f":"VLOOKUP(B19,[1]Projects!$B:$L,11,0)","v":"D"},254231.1799999997,3718649.48,{"$f":"+G19-Y19","v":392804.16000000015},{"$f":"+H19-Z19","v":392804.16000000015},{"$f":"+H19/F19","v":1},{"$f":"+G19/E19","v":0.99230101570244367},{"$f":"IF(K19>G19,K19-G19,0)","v":0},{"$f":"IF(G19>K19,G19-K19,0)","v":390920.06999999937},{"$f":"+R19-S19","v":7.6989842975563327E-3},{"$f":"+I19-T19","v":0},{"$f":"+J19-U19","v":6.4028427004814148E-10},4787528.0999999996,4533296.92]
["CORPO001","10-T9002-Bs","Termozulia IV-In Country",107002,4600000,4883422.78,4600000,7540413.1299999999,0,0,4600000,{"$f":"G20-H20","v":-2940413.13},{"$f":"VLOOKUP(B20,[1]Projects!$B:$L,11,0)","v":"I-Foreign"},-2940413.13,2300000,0,579553.91,1,{"$f":"G20/E20","v":1},{"$f":"K20-G20","v":0},0,0,0,0,0,1571134.67]
["GENATL001","ENG08-1127 REV1","Engineering Services","104002",3100000,2630000,2945000,2498500,155000,0,3100000,{"$f":"+G21-H21","v":446500},{"$f":"VLOOKUP(B21,[1]Projects!$B:$L,11,0)","v":"D"},446500,2945000,{"$f":"+G21-Y21","v":0},{"$f":"+H21-Z21","v":0},{"$f":"+H21/F21","v":0.95},{"$f":"+G21/E21","v":0.95},{"$f":"IF(K21>G21,K21-G21,0)","v":155000},{"$f":"IF(G21>K21,G21-K21,0)","v":0},{"$f":"+R21-S21","v":0},{"$f":"+I21-T21","v":0},{"$f":"+J21-U21","v":0},2945000,2498500]
["PACIFICRIM001","FS07-0344JOS-1","Josefa Extra Costs","104002",3000000,3000000,1701500,1206655.33,1298500,0,3000000,{"$f":"+G22-H22","v":494844.66999999993},{"$f":"VLOOKUP(B22,[1]Projects!$B:$L,11,0)","v":"I"},494844.66999999993,3000000,{"$f":"+G22-Y22","v":-100000},{"$f":"+H22-Z22","v":5259.9500000001863},{"$f":"+H22/F22","v":0.40221844333333334},{"$f":"+G22/E22","v":0.56716666666666671},{"$f":"IF(K22>G22,K22-G22,0)","v":1298500},{"$f":"IF(G22>K22,G22-K22,0)","v":0},{"$f":"+R22-S22","v":-0.16494822333333337},{"$f":"+I22-T22","v":0},{"$f":"+J22-U22","v":0},1801500,1201395.3799999999]
["NPPD001","409-2885","Fire Protection Upgrade","104014",2735978,2089047.71,1342544.4,1025166.98,0,330104.59000000003,1012439.81,{"$f":"+G23-H23","v":317377.41999999993},{"$f":"VLOOKUP(B23,[1]Projects!$B:$L,11,0)","v":"D"},317377.41999999993,833454.79,{"$f":"+G23-Y23","v":191685.91999999993},{"$f":"+H23-Z23","v":144025.80999999994},{"$f":"+H23/F23","v":0.49073411540227579},{"$f":"+G23/E23","v":0.49069999831869987},{"$f":"IF(K23>G23,K23-G23,0)","v":0},{"$f":"IF(G23>K23,G23-K23,0)","v":330104.58999999985},{"$f":"+R23-S23","v":3.4117083575924134E-5},{"$f":"+I23-T23","v":0},{"$f":"+J23-U23","v":0},1150858.48,881141.17]
["EMGASUD001","OM08-1239 O&M-M","Matheu O&M","101160",2516697,1798502.01,1639380,1171546,392587,0,2031967,{"$f":"+G24-H24","v":467834},{"$f":"VLOOKUP(B24,[1]Projects!$B:$L,11,0)","v":"I"},467834,1896408,{"$f":"+G24-Z24","v":547220},{"$f":"+H24-AA24","v":1171546},{"$f":"+H24/F24","v":0.65140099565415555},{"$f":"+G24/E24","v":0.65140142019480296},{"$f":"IF(K24>G24,K24-G24,0)","v":392587},{"$f":"IF(G24>K24,G24-K24,0)","v":0},{"$f":"+R24-S24","v":-4.2454064741459518E-7},{"$f":"+I24-T24","v":0},{"$f":"+J24-U24","v":0},1528292,1092160]
["GENATL001","OM07-0509 O&M2","TermoColon O&M","101150",2500000,2131659,2500000,{"$f":"2155268-23609","v":2131659},0,383065,2116935,{"$f":"+G25-H25","v":368341},{"$f":"VLOOKUP(B25,[1]Projects!$B:$L,11,0)","v":"I"},368341,1575000,{"$f":"+G25-Z25","v":368341},{"$f":"+H25-AA25","v":2131659},{"$f":"+H25/F25","v":1},{"$f":"+G25/E25","v":1},{"$f":"IF(K25>G25,K25-G25,0)","v":0},{"$f":"IF(G25>K25,G25-K25,0)","v":383065},{"$f":"+R25-S25","v":0},{"$f":"+I25-T25","v":0},{"$f":"+J25-U25","v":0},2500000,{"$f":"2155268-23609","v":2131659}]
["INOTEC001","110-3353 REV 3","Operations & Maintenance","101220",2200782,1955944,0,0,0,0,0,{"$f":"+G26-H26","v":0},"I",0,0,{"$f":"+G26-Y26","v":0},{"$f":"+H26-Z26","v":0},{"$f":"+H26/F26","v":0},{"$f":"+G26/E26","v":0},{"$f":"IF(K26>G26,K26-G26,0)","v":0},{"$f":"IF(G26>K26,G26-K26,0)","v":0},{"$f":"+R26-S26","v":0},{"$f":"+I26-T26","v":0},{"$f":"+J26-U26","v":0},0,0]
["WALTONCONST001","409-2513 REV 2","Tinker AFB - Warehouse","104013",2074060,1859561.84,92917.89,83391.8,0,92917.89,0,{"$f":"+G27-H27","v":9526.0899999999965},{"$f":"VLOOKUP(B27,[1]Projects!$B:$L,11,0)","v":"D"},9526.0899999999965,0,{"$f":"+G27-Y27","v":12236.960000000006},{"$f":"+H27-Z27","v":11097.130000000005},{"$f":"+H27/F27","v":4.4844865175336139E-2},{"$f":"+G27/E27","v":4.4800000964292257E-2},{"$f":"IF(K27>G27,K27-G27,0)","v":0},{"$f":"IF(G27>K27,G27-K27,0)","v":92917.89},{"$f":"+R27-S27","v":4.4864211043882385E-5},{"$f":"+I27-T27","v":0},{"$f":"+J27-U27","v":0},80680.929999999993,72294.67]
["GENATL001","OM07-0509 MOBSC2","TermoColon Mobilization","101150",1500000,1259219,1117674,938265,382326,0,1500000,{"$f":"+G28-H28","v":179409},{"$f":"VLOOKUP(B28,[1]Projects!$B:$L,11,0)","v":"I"},179409,1026013.7,{"$f":"+G28-Z28","v":187021},{"$f":"+H28-AA28","v":938265},{"$f":"+H28/F28","v":0.74511661593416234},{"$f":"+G28/E28","v":0.745116},{"$f":"IF(K28>G28,K28-G28,0)","v":382326},{"$f":"IF(G28>K28,G28-K28,0)","v":0},{"$f":"+R28-S28","v":6.159341623401815E-7},{"$f":"+I28-T28","v":0},{"$f":"+J28-U28","v":0},1108607,930653]
["VTPUBPOW001","410-3169 REV 1","P10 Generator No 2 Repair","104002",1420000,1194767.6299999999,1420000,1194767.6299999999,0,0,1420000,{"$f":"+G29-H29","v":225232.37000000011},{"$f":"VLOOKUP(B29,[1]Projects!$B:$L,11,0)","v":"D"},225232.37000000011,1420000,{"$f":"+G29-Y29","v":0},{"$f":"+H29-Z29","v":15784.039999999804},{"$f":"+H29/F29","v":1},{"$f":"+G29/E29","v":1},{"$f":"IF(K29>G29,K29-G29,0)","v":0},{"$f":"IF(G29>K29,G29-K29,0)","v":0},{"$f":"+R29-S29","v":0},{"$f":"+I29-T29","v":0},{"$f":"+J29-U29","v":0},1420000,1178983.5900000001]
["EMGASUD001","OM08-1239 O&M-P","Parana O&M","101170",1232946,1051681,825510,704145,556736,0,1382246,{"$f":"+G30-H30","v":121365},{"$f":"VLOOKUP(B30,[1]Projects!$B:$L,11,0)","v":"I"},121365,1211665,{"$f":"+G30-Z30","v":201759},{"$f":"+H30-AA30","v":704145},{"$f":"+H30/F30","v":0.66954238024648161},{"$f":"+G30/E30","v":0.66954270503331048},{"$f":"IF(K30>G30,K30-G30,0)","v":556736},{"$f":"IF(G30>K30,G30-K30,0)","v":0},{"$f":"+R30-S30","v":-3.2478682887582266E-7},{"$f":"+I30-T30","v":0},{"$f":"+J30-U30","v":0},731259,623751]
["INOTEC001","110-3353 INV","Inventory Costs","101220",1110121.47,1200000,0,0,0,0,0,{"$f":"+G31-H31","v":0},"I",0,0,{"$f":"+G31-Y31","v":0},{"$f":"+H31-Z31","v":0},{"$f":"+H31/F31","v":0},{"$f":"+G31/E31","v":0},{"$f":"IF(K31>G31,K31-G31,0)","v":0},{"$f":"IF(G31>K31,G31-K31,0)","v":0},{"$f":"+R31-S31","v":0},{"$f":"+I31-T31","v":0},{"$f":"+J31-U31","v":0},0,0]
["INOTEC001","110-3353 MOB","Angola Mobilization","105009",1098394,878715,8128.12,6526.82,0,8128.12,0,{"$f":"+G32-H32","v":1601.3000000000002},"I",1601.3000000000002,0,{"$f":"+G32-Y32","v":8128.12},{"$f":"+H32-Z32","v":6526.82},{"$f":"+H32/F32","v":7.4276870202511615E-3},{"$f":"+G32/E32","v":7.4000040058485386E-3},{"$f":"IF(K32>G32,K32-G32,0)","v":0},{"$f":"IF(G32>K32,G32-K32,0)","v":8128.12},{"$f":"+R32-S32","v":2.7683014402622892E-5},{"$f":"+I32-T32","v":0},{"$f":"+J32-U32","v":0},0,0]
["GENATL001","OM07-0509 RS","Repair Services - TermoColon","101150",1081063.8700000001,982181.16,722583.09,656489.89,267935.09000000003,0,{"$f":"1081017.68-90499.5","v":990518.17999999993},{"$f":"+G33-H33","v":66093.199999999953},{"$f":"VLOOKUP(B33,[1]Projects!$B:$L,11,0)","v":"I"},66093.199999999953,0,{"$f":"+G33-Y33","v":26909.729999999981},{"$f":"+H33-Z33","v":24412.380000000005},{"$f":"+H33/F33","v":0.66840000270418543},{"$f":"+G33/E33","v":0.66839999934508942},{"$f":"IF(K33>G33,K33-G33,0)","v":267935.08999999997},{"$f":"IF(G33>K33,G33-K33,0)","v":0},{"$f":"+R33-S33","v":3.3590960013540894E-9},{"$f":"+I33-T33","v":0},{"$f":"+J33-U33","v":0},695673.36,632077.51]
["OMPA001","409-2227","Steam Turbine Overhaul","104004",1014356.5,790142.16,955523.82,744290.03,58832.68,0,1014356.5,{"$f":"+G34-H34","v":211233.78999999992},{"$f":"VLOOKUP(B34,[1]Projects!$B:$L,11,0)","v":"D"},211233.78999999992,954066.5,{"$f":"+G34-Y34","v":4260.2899999999208},{"$f":"+H34-Z34","v":3337.8100000000559},{"$f":"+H34/F34","v":0.94196977161679363},{"$f":"+G34/E34","v":0.94199999704245985},{"$f":"IF(K34>G34,K34-G34,0)","v":58832.680000000051},{"$f":"IF(G34>K34,G34-K34,0)","v":0},{"$f":"+R34-S34","v":-3.022542566621933E-5},{"$f":"+I34-T34","v":0},{"$f":"+J34-U34","v":0},951263.53,740952.22]
["GENATL001","OM07-0509 SP-CC","Spares - Combined Cycle","101150",1000000,856071,464000,397243.72,536000,0,1000000,{"$f":"+G35-H35","v":66756.280000000028},{"$f":"VLOOKUP(B35,[1]Projects!$B:$L,11,0)","v":"I"},66756.280000000028,0,{"$f":"+G35-Y35","v":4200},{"$f":"+H35-Z35","v":3613.1499999999651},{"$f":"+H35/F35","v":0.46403127777952996},{"$f":"+G35/E35","v":0.46400000000000002},{"$f":"IF(K35>G35,K35-G35,0)","v":536000},{"$f":"IF(G35>K35,G35-K35,0)","v":0},{"$f":"+R35-S35","v":3.1277779529936822E-5},{"$f":"+I35-T35","v":0},{"$f":"+J35-U35","v":0},459800,393630.57]
["PROEPC001","109-2317 MOB","Naudero Mobilization","105009",900000,765000,620190,527155.26,279810,0,900000,{"$f":"+G36-H36","v":93034.739999999991},{"$f":"VLOOKUP(B36,[1]Projects!$B:$L,11,0)","v":"I"},93034.739999999991,877720.12,{"$f":"+G36-Y36","v":144630},{"$f":"+H36-Z36","v":122898.5},{"$f":"+H36/F36","v":0.68909184313725491},{"$f":"+G36/E36","v":0.68910000000000005},{"$f":"IF(K36>G36,K36-G36,0)","v":279810},{"$f":"IF(G36>K36,G36-K36,0)","v":0},{"$f":"+R36-S36","v":-8.1568627451344966E-6},{"$f":"+I36-T36","v":0},{"$f":"+J36-U36","v":0},475560,404256.76]
["JOHNCONTBLD001","FS08-1422 REV4","Central Heating Contrl Upgrade","105004",862750,614815.46,469594.83,334619.40999999997,0,340182.33,129412.5,{"$f":"+G37-H37","v":134975.42000000004},{"$f":"VLOOKUP(B37,[1]Projects!$B:$L,11,0)","v":"D"},134975.42000000004,129412.5,{"$f":"+G37-Y37","v":271852.53000000003},{"$f":"+H37-Z37","v":193731.92999999996},{"$f":"+H37/F37","v":0.54425991499953497},{"$f":"+G37/E37","v":0.54430000579542159},{"$f":"IF(K37>G37,K37-G37,0)","v":0},{"$f":"IF(G37>K37,G37-K37,0)","v":340182.33},{"$f":"+R37-S37","v":-4.0090795886627006E-5},{"$f":"+I37-T37","v":0},{"$f":"+J37-U37","v":0},197742.3,140887.48000000001]
["EMGASUD001","OM08-1239 RS-M1","Emgasud Matheu Repair Ser Fee","101160",843588.11,707953,0,0,{"$f":"292318.11+56250","v":348568.11},0,{"$f":"367318.11-18750","v":348568.11},{"$f":"+G38-H38","v":0},{"$f":"VLOOKUP(B38,[1]Projects!$B:$L,11,0)","v":"I"},0,251250,{"$f":"+G38-Y38","v":0},{"$f":"+H38-Z38","v":0},{"$f":"+H38/F38","v":0},{"$f":"+G38/E38","v":0},{"$f":"IF(K38>G38,K38-G38,0)","v":348568.11},{"$f":"IF(G38>K38,G38-K38,0)","v":0},{"$f":"+R38-S38","v":0},{"$f":"+I38-T38","v":0},{"$f":"+J38-U38","v":0},0,0]
["GENATL001","OM07-0509 SP-SC","Spares - Simple Cycle","101150",500000,507566.27,498800,506348.11,1200,0,500000,{"$f":"+G39-H39","v":-7548.109999999986},{"$f":"VLOOKUP(B39,[1]Projects!$B:$L,11,0)","v":"I"},-7548.109999999986,500000,{"$f":"+G39-Y39","v":0},{"$f":"+H39-Z39","v":25.429999999993015},{"$f":"+H39/F39","v":0.99759999812438283},{"$f":"+G39/E39","v":0.99760000000000004},{"$f":"IF(K39>G39,K39-G39,0)","v":1200},{"$f":"IF(G39>K39,G39-K39,0)","v":0},{"$f":"+R39-S39","v":-1.8756172170952823E-9},{"$f":"+I39-T39","v":0},{"$f":"+J39-U39","v":0},498800,506322.68]
["STRAUB001","FS08-1708","City of W'burg PDHQ","104013",499901.66,573107.06000000006,499901.66,573107.06000000006,0,0,499901.66,{"$f":"+G40-H40","v":-73205.400000000081},{"$f":"VLOOKUP(B40,[1]Projects!$B:$L,11,0)","v":"D"},-73205.400000000081,421755.66,{"$f":"+G40-Y40","v":0},{"$f":"+H40-Z40","v":1868.1600000000326},{"$f":"+H40/F40","v":1},{"$f":"+G40/E40","v":1},{"$f":"IF(K40>G40,K40-G40,0)","v":0},{"$f":"IF(G40>K40,G40-K40,0)","v":0},{"$f":"+R40-S40","v":0},{"$f":"+I40-T40","v":0},{"$f":"+J40-U40","v":0},499901.66,571238.9]
["PUBLICPOWER001","609-2908","Coal Dumper Bldg Modifications","100001",394846,321036.44,394846,225128.4,0,0,394846,{"$f":"+G41-H41","v":169717.6},{"$f":"VLOOKUP(B41,[1]Projects!$B:$L,11,0)","v":"D"},169717.6,394846,{"$f":"+G41-Y41","v":0},{"$f":"+H41-Z41","v":134.25999999998021},{"$f":"+H41/F41","v":0.70125497279997251},{"$f":"+G41/E41","v":1},{"$f":"IF(K41>G41,K41-G41,0)","v":0},{"$f":"IF(G41>K41,G41-K41,0)","v":0},{"$f":"+R41-S41","v":-0.29874502720002749},{"$f":"+I41-T41","v":0},{"$f":"+J41-U41","v":0},394846,224994.14]
["PROEPC001","109-2317 ININV","Naudero Initial Inventory Part","101200",300000,272727.27,8340,7581.82,{"$f":"300000-8340","v":291660},0,{"$f":"300000","v":300000},{"$f":"+G42-H42","v":758.18000000000029},{"$f":"VLOOKUP(B42,[1]Projects!$B:$L,11,0)","v":"I"},758.18000000000029,300000,{"$f":"+G42-Y42","v":8340},{"$f":"+H42-Z42","v":7581.82},{"$f":"+H42/F42","v":2.7800006944666732E-2},{"$f":"+G42/E42","v":2.7799999999999998E-2},{"$f":"IF(K42>G42,K42-G42,0)","v":291660},{"$f":"IF(G42>K42,G42-K42,0)","v":0},{"$f":"+R42-S42","v":6.9446667340378188E-9},{"$f":"+I42-T42","v":0},{"$f":"+J42-U42","v":0},0,0]
["EMGASUD001","OM08-1239 RS-P1","Emgasud Parana Repair Ser Fee","101170",238832.5,244953.4,0,0,{"$f":"163832.5+56250","v":220082.5},0,{"$f":"238832.5-18750","v":220082.5},{"$f":"+G43-H43","v":0},{"$f":"VLOOKUP(B43,[1]Projects!$B:$L,11,0)","v":"I"},0,106250,{"$f":"+G43-Y43","v":0},{"$f":"+H43-Z43","v":0},{"$f":"+H43/F43","v":0},{"$f":"+G43/E43","v":0},{"$f":"IF(K43>G43,K43-G43,0)","v":220082.5},{"$f":"IF(G43>K43,G43-K43,0)","v":0},{"$f":"+R43-S43","v":0},{"$f":"+I43-T43","v":0},{"$f":"+J43-U43","v":0},0,0]
["CITYO000020CLEM","410-3110","GE 35 MW Steam Turbine Inspec","104002",238626,185432.34,162361.13,126173.44,0,43048.13,119313,{"$f":"+G44-H44","v":36187.69},{"$f":"VLOOKUP(B44,[1]Projects!$B:$L,11,0)","v":"D"},36187.69,0,{"$f":"+G44-Y44","v":66051.680000000008},{"$f":"+H44-Z44","v":51326.47},{"$f":"+H44/F44","v":0.68042845169294641},{"$f":"+G44/E44","v":0.68039999832373677},{"$f":"IF(K44>G44,K44-G44,0)","v":0},{"$f":"IF(G44>K44,G44-K44,0)","v":43048.130000000005},{"$f":"+R44-S44","v":2.8453369209646695E-5},{"$f":"+I44-T44","v":0},{"$f":"+J44-U44","v":0},96309.45,74846.97]
["SEPTAG001","409-2302","Sedalia Streetscapes","104013",235226.25,304654.42,235226.25,304654.42,0,0,235226.25,{"$f":"+G45-H45","v":-69428.169999999984},{"$f":"VLOOKUP(B45,[1]Projects!$B:$L,11,0)","v":"D"},-69428.169999999984,235226.25,{"$f":"+G45-Y45","v":0},{"$f":"+H45-Z45","v":0},{"$f":"+H45/F45","v":1},{"$f":"+G45/E45","v":1},{"$f":"IF(K45>G45,K45-G45,0)","v":0},{"$f":"IF(G45>K45,G45-K45,0)","v":0},{"$f":"+R45-S45","v":0},{"$f":"+I45-T45","v":0},{"$f":"+J45-U45","v":0},235226.25,304654.42]
["OG&E001","409-2828 REV 2","HRSG Perforated Plates","104012",211200,187603.20000000001,188728.32000000001,167649.01999999999,22471.68,0,211200,{"$f":"+G46-H46","v":21079.300000000017},{"$f":"VLOOKUP(B46,[1]Projects!$B:$L,11,0)","v":"D"},21079.300000000017,211200,{"$f":"+G46-Y46","v":21.119999999995343},{"$f":"+H46-Z46","v":30},{"$f":"+H46/F46","v":0.89363624927506558},{"$f":"+G46/E46","v":0.89360000000000006},{"$f":"IF(K46>G46,K46-G46,0)","v":22471.679999999993},{"$f":"IF(G46>K46,G46-K46,0)","v":0},{"$f":"+R46-S46","v":3.6249275065514119E-5},{"$f":"+I46-T46","v":0},{"$f":"+J46-U46","v":0},188707.20000000001,167619.01999999999]
["OMU001","409-2659","Air Heater Basket Replacement","104012",199440,100991.05,199440,100991.05,0,0,199440,{"$f":"+G47-H47","v":98448.95},{"$f":"VLOOKUP(B47,[1]Projects!$B:$L,11,0)","v":"D"},98448.95,199440,{"$f":"+G47-Y47","v":0},{"$f":"+H47-Z47","v":0},{"$f":"+H47/F47","v":1},{"$f":"+G47/E47","v":1},{"$f":"IF(K47>G47,K47-G47,0)","v":0},{"$f":"IF(G47>K47,G47-K47,0)","v":0},{"$f":"+R47-S47","v":0},{"$f":"+I47-T47","v":0},{"$f":"+J47-U47","v":0},199440,100991.05]
["CITYOFSP001","410-3163","Steam Drum Internals Repl","104012",195575.63,145648.17000000001,182902.33,136205.95000000001,12673.3,0,195575.63,{"$f":"+G48-H48","v":46696.379999999976},{"$f":"VLOOKUP(B48,[1]Projects!$B:$L,11,0)","v":"D"},46696.379999999976,195575.63,{"$f":"+G48-Y48","v":1193.0099999999802},{"$f":"+H48-Z48","v":885.72000000000116},{"$f":"+H48/F48","v":0.93517103579124961},{"$f":"+G48/E48","v":0.93520000421320382},{"$f":"IF(K48>G48,K48-G48,0)","v":12673.300000000017},{"$f":"IF(G48>K48,G48-K48,0)","v":0},{"$f":"+R48-S48","v":-2.8968421954211898E-5},{"$f":"+I48-T48","v":-1.8189894035458565E-11},{"$f":"+J48-U48","v":0},181709.32,135320.23000000001]
["ISOLUX001","109-2785 BMOB","Batanga Mobilization","101210",161000,116000,126562.1,90905.51,34437.9,0,161000,{"$f":"+G49-H49","v":35656.590000000011},{"$f":"VLOOKUP(B49,[1]Projects!$B:$L,11,0)","v":"I"},35656.590000000011,0,{"$f":"+G49-Y49","v":386.40000000000873},{"$f":"+H49-Z49","v":0},{"$f":"+H49/F49","v":0.78366818965517238},{"$f":"+G49/E49","v":0.78610000000000002},{"$f":"IF(K49>G49,K49-G49,0)","v":34437.899999999994},{"$f":"IF(G49>K49,G49-K49,0)","v":0},{"$f":"+R49-S49","v":-2.4318103448276451E-3},{"$f":"+I49-T49","v":0},{"$f":"+J49-U49","v":0},126175.7,90905.51]
[null,null,"Total Projects < $150K",null,{"$f":"E100","v":1537793.43},{"$f":"F100","v":1342450.6499999997},1279315.3900000001,1237401.8799999997,70351.180000000008,172607.13999999998,1177059.43,41913.509999999987,{"$error":"#N/A"},41913.510000000475,943172.85000000009,135168.97,115555.48,33.621531957276503,31.801576505324501,70351.180000000008,172607.13999999998,1.8199554519519989,0,0,1144146.4200000004,1121846.4000000004]
[]
[null,null,"Total Revenue Recognition",null,{"$f":"SUM(E2:E51)","v":715435832.56999993},{"$f":"SUM(F2:F51)","v":636666039.62999988},169156547.78999999,150405771.38,140520250.93000007,9569695.8100000024,300107102.91000009,{"$f":"SUM(L2:L51)","v":18750776.410000011},{"$f":"SUM(M2:M51)","v":{"$error":"#N/A"}},{"$f":"SUM(N2:N51)","v":18750776.410000011},203187018.98999995,29242264.450000003,30945272.149999995,57.926550590097847,56.600617349010435,140520250.93000004,9569695.8100000005,1.3259008855525396,-1.8189894035458565E-11,6.4028427004814148E-10,120349732.29000001,104355471.96000001]
[]
[]
[]
[]
["EPS001","510-3156","ABB Backup Generator Repair","105008",140793.79,116000,88122.83,72600.08,52670.96,0,140793.79,{"$f":"+G57-H57","v":15522.75},{"$f":"VLOOKUP(B57,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,140793.79,{"$f":"+G57-Y57","v":14781.520000000004},{"$f":"+H57-Z57","v":16298.61},{"$f":"+H57/F57","v":0.62586275862068963},{"$f":"+G57/E57","v":0.62589997754872562},{"$f":"IF(K57>G57,K57-G57,0)","v":52670.960000000006},{"$f":"IF(G57>K57,G57-K57,0)","v":0},{"$f":"+R57-S57","v":-3.721892803598692E-5},{"$f":"+I57-T57","v":0},{"$f":"+J57-U57","v":0},73341.31,56301.47]
["MWALLSTAR001","409-2764 REV 1","HS 3030 Network Fire Alarm","104014",140000,107597.73,140000,107597.73,0,0,140000,{"$f":"+G58-H58","v":32402.270000000004},{"$f":"VLOOKUP(B58,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,126000,{"$f":"+G58-Y58","v":0},{"$f":"+H58-Z58","v":0},{"$f":"+H58/F58","v":1},{"$f":"+G58/E58","v":1},{"$f":"IF(K58>G58,K58-G58,0)","v":0},{"$f":"IF(G58>K58,G58-K58,0)","v":0},{"$f":"+R58-S58","v":0},{"$f":"+I58-T58","v":0},{"$f":"+J58-U58","v":0},140000,107597.73]
["COIL001","FS08-1124 REV4","PW Facility Warrensburg, MO","104005",130782,276284.15000000002,130782,276284.15000000002,0,0,130782,{"$f":"+G59-H59","v":-145502.15000000002},{"$f":"VLOOKUP(B59,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,117703.8,{"$f":"+G59-Y59","v":0},{"$f":"+H59-Z59","v":0},{"$f":"+H59/F59","v":1},{"$f":"+G59/E59","v":1},{"$f":"IF(K59>G59,K59-G59,0)","v":0},{"$f":"IF(G59>K59,G59-K59,0)","v":0},{"$f":"+R59-S59","v":0},{"$f":"+I59-T59","v":0},{"$f":"+J59-U59","v":0},130782,276284.15000000002]
["CALEN000020HWEM","409-2942 REV 1","CI & Alignment Steam Turbine","104002",112092,103385.64,112092,103385.64,0,0,112092,{"$f":"+G60-H60","v":8706.36},{"$f":"VLOOKUP(B60,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,12692,{"$f":"+G60-Y60","v":0},{"$f":"+H60-Z60","v":0},{"$f":"+H60/F60","v":1},{"$f":"+G60/E60","v":1},{"$f":"IF(K60>G60,K60-G60,0)","v":0},{"$f":"IF(G60>K60,G60-K60,0)","v":0},{"$f":"+R60-S60","v":0},{"$f":"+I60-T60","v":0},{"$f":"+J60-U60","v":0},112092,103385.64]
["EMERS001","FS08-1251 REV 2","Mark V Engr Lead","105004",106750,73040,106750,161048.59,0,10675,96075,{"$f":"+G61-H61","v":-54298.59},{"$f":"VLOOKUP(B61,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,96075,{"$f":"+G61-Y61","v":0},{"$f":"+H61-Z61","v":0},{"$f":"+H61/F61","v":2.2049368838992334},{"$f":"+G61/E61","v":1},{"$f":"IF(K61>G61,K61-G61,0)","v":0},{"$f":"IF(G61>K61,G61-K61,0)","v":10675},{"$f":"+R61-S61","v":1.2049368838992334},{"$f":"+I61-T61","v":0},{"$f":"+J61-U61","v":0},106750,161048.59]
["CITYO000020CLEM","410-3110 EW01","Steam Turbine Overhaul","104002",95940,79950,47970,39975,0,47970,0,{"$f":"+G62-H62","v":7995},{"$f":"VLOOKUP(B62,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G62-Y62","v":47970},{"$f":"+H62-Z62","v":39975},{"$f":"+H62/F62","v":0.5},{"$f":"+G62/E62","v":0.5},{"$f":"IF(K62>G62,K62-G62,0)","v":0},{"$f":"IF(G62>K62,G62-K62,0)","v":47970},{"$f":"+R62-S62","v":0},{"$f":"+I62-T62","v":0},{"$f":"+J62-U62","v":0},0,0]
["HASTING001","610-3220","Steam Seal Modification","100001",91468,68203.070000000007,91468,57816.63,0,0,91468,{"$f":"+G63-H63","v":33651.370000000003},{"$f":"VLOOKUP(B63,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,88723.96,{"$f":"+G63-Y63","v":0},{"$f":"+H63-Z63","v":106.57999999999447},{"$f":"+H63/F63","v":0.84771301350511041},{"$f":"+G63/E63","v":1},{"$f":"IF(K63>G63,K63-G63,0)","v":0},{"$f":"IF(G63>K63,G63-K63,0)","v":0},{"$f":"+R63-S63","v":-0.15228698649488959},{"$f":"+I63-T63","v":0},{"$f":"+J63-U63","v":0},91468,57710.05]
["MWALLSTAR001","409-2843 REV 3","WAFB T-9","104013",72318,60404.65,56914.27,47535.33,15403.73,0,72318,{"$f":"+G64-H64","v":9378.9399999999951},{"$f":"VLOOKUP(B64,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G64-Y64","v":1366.8099999999977},{"$f":"+H64-Z64","v":1136.0600000000049},{"$f":"+H64/F64","v":0.78694819024694296},{"$f":"+G64/E64","v":0.78700005531126405},{"$f":"IF(K64>G64,K64-G64,0)","v":15403.730000000003},{"$f":"IF(G64>K64,G64-K64,0)","v":0},{"$f":"+R64-S64","v":-5.1865064321088283E-5},{"$f":"+I64-T64","v":0},{"$f":"+J64-U64","v":0},55547.46,46399.27]
["VICWLE001","409-2958","Steam Valve Inspection","104002",67055,50374.97,67055,50374.97,0,0,67055,{"$f":"+G65-H65","v":16680.03},{"$f":"VLOOKUP(B65,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,67055,{"$f":"+G65-Y65","v":0},{"$f":"+H65-Z65","v":0},{"$f":"+H65/F65","v":1},{"$f":"+G65/E65","v":1},{"$f":"IF(K65>G65,K65-G65,0)","v":0},{"$f":"IF(G65>K65,G65-K65,0)","v":0},{"$f":"+R65-S65","v":0},{"$f":"+I65-T65","v":0},{"$f":"+J65-U65","v":0},67055,50374.97]
["CONSTRUCTION001","210-3148","Field Engineer","100001",49489,23930.46,49489,23930.46,0,0,49489,{"$f":"+G66-H66","v":25558.54},{"$f":"VLOOKUP(B66,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,49489,{"$f":"+G66-Y66","v":0},{"$f":"+H66-Z66","v":1330.3400000000001},{"$f":"+H66/F66","v":1},{"$f":"+G66/E66","v":1},{"$f":"IF(K66>G66,K66-G66,0)","v":0},{"$f":"IF(G66>K66,G66-K66,0)","v":0},{"$f":"+R66-S66","v":0},{"$f":"+I66-T66","v":0},{"$f":"+J66-U66","v":0},49489,22600.12]
["SEPTAG001","409-2847","Biosolids Composting Facility","104013",46754,40671.129999999997,45468.27,39554.44,0,28007.27,17461,{"$f":"+G67-H67","v":5913.8299999999945},{"$f":"VLOOKUP(B67,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,15714.9,{"$f":"+G67-Y67","v":18364.979999999996},{"$f":"+H67-Z67","v":15977.670000000002},{"$f":"+H67/F67","v":0.97254342330788457},{"$f":"+G67/E67","v":0.97250010694272138},{"$f":"IF(K67>G67,K67-G67,0)","v":0},{"$f":"IF(G67>K67,G67-K67,0)","v":28007.269999999997},{"$f":"+R67-S67","v":4.3316365163192927E-5},{"$f":"+I67-T67","v":0},{"$f":"+J67-U67","v":0},27103.29,23576.77]
["MWALLSTAR001","409-2844 REV 1","Upgrade Dormitory Campus","104013",45320,39411.14,16981.400000000001,14768.09,0,16981.400000000001,0,{"$f":"+G68-H68","v":2213.3100000000013},{"$f":"VLOOKUP(B68,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G68-Y68","v":58.909999999999854},{"$f":"+H68-Z68","v":52.8700000000008},{"$f":"+H68/F68","v":0.37471867091385835},{"$f":"+G68/E68","v":0.37469991173874673},{"$f":"IF(K68>G68,K68-G68,0)","v":0},{"$f":"IF(G68>K68,G68-K68,0)","v":16981.400000000001},{"$f":"+R68-S68","v":1.8759175111626725E-5},{"$f":"+I68-T68","v":0},{"$f":"+J68-U68","v":0},16922.490000000002,14715.22]
["TRISTATE001","410-3219","Exhaust Welding","104005",42825,17394.509999999998,42825,17394.509999999998,0,0,42825,{"$f":"+G69-H69","v":25430.49},{"$f":"VLOOKUP(B69,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,42825,{"$f":"+G69-Y69","v":0},{"$f":"+H69-Z69","v":66.709999999999127},{"$f":"+H69/F69","v":1},{"$f":"+G69/E69","v":1},{"$f":"IF(K69>G69,K69-G69,0)","v":0},{"$f":"IF(G69>K69,G69-K69,0)","v":0},{"$f":"+R69-S69","v":0},{"$f":"+I69-T69","v":0},{"$f":"+J69-U69","v":0},42825,17327.8]
["KCPL001","410-3223","Transformer Fire Protection","104014",40905,29692.21,40905,29692.21,0,0,40905,{"$f":"+G70-H70","v":11212.79},{"$f":"VLOOKUP(B70,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,40905,{"$f":"+G70-Y70","v":355.87000000000262},{"$f":"+H70-Z70","v":1491.5400000000009},{"$f":"+H70/F70","v":1},{"$f":"+G70/E70","v":1},{"$f":"IF(K70>G70,K70-G70,0)","v":0},{"$f":"IF(G70>K70,G70-K70,0)","v":0},{"$f":"+R70-S70","v":0},{"$f":"+I70-T70","v":0},{"$f":"+J70-U70","v":0},40549.129999999997,28200.67]
["TOSHAMER001","2009-05","Technical Training - Whelan","105003",30000,13875,30000,11955.15,0,0,30000,{"$f":"+G71-H71","v":18044.849999999999},{"$f":"VLOOKUP(B71,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,30000,{"$f":"+G71-Y71","v":0},{"$f":"+H71-Z71","v":0},{"$f":"+H71/F71","v":0.86163243243243237},{"$f":"+G71/E71","v":1},{"$f":"IF(K71>G71,K71-G71,0)","v":0},{"$f":"IF(G71>K71,G71-K71,0)","v":0},{"$f":"+R71-S71","v":-0.13836756756756763},{"$f":"+I71-T71","v":0},{"$f":"+J71-U71","v":0},30000,11955.15]
["CITYSEDALIA001","409-3107","Liberty Park","104013",26475,21118.38,22043.09,17583.990000000002,0,863.09,21180,{"$f":"+G72-H72","v":4459.0999999999985},{"$f":"VLOOKUP(B72,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,19062,{"$f":"+G72-Y72","v":0},{"$f":"+H72-Z72","v":0},{"$f":"+H72/F72","v":0.83263915129853716},{"$f":"+G72/E72","v":0.8326001888574126},{"$f":"IF(K72>G72,K72-G72,0)","v":0},{"$f":"IF(G72>K72,G72-K72,0)","v":863.09000000000015},{"$f":"+R72-S72","v":3.8962441124557046E-5},{"$f":"+I72-T72","v":0},{"$f":"+J72-U72","v":0},22043.09,17583.990000000002]
["MCCONEX001","409-2732","Traffic Signal Work","104013",26419,23625.47,17193.490000000002,15375.78,0,17193.490000000002,0,{"$f":"+G73-H73","v":1817.7100000000009},{"$f":"VLOOKUP(B73,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G73-Y73","v":3241.6200000000008},{"$f":"+H73-Z73","v":2900.3700000000008},{"$f":"+H73/F73","v":0.65081371926145803},{"$f":"+G73/E73","v":0.65080018168742204},{"$f":"IF(K73>G73,K73-G73,0)","v":0},{"$f":"IF(G73>K73,G73-K73,0)","v":17193.490000000002},{"$f":"+R73-S73","v":1.3537574035993316E-5},{"$f":"+I73-T73","v":0},{"$f":"+J73-U73","v":0},13951.87,12475.41]
["AMERENUE001","109-2899 MOB","June'10 Ameren Mobilization","105009",26400,23760,26400,43673.4,0,0,26400,{"$f":"+G74-H74","v":-17273.400000000001},{"$f":"VLOOKUP(B74,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,26400,{"$f":"+G74-Y74","v":4994.880000000001},{"$f":"+H74-Z74","v":24409.050000000003},{"$f":"+H74/F74","v":1.8381060606060606},{"$f":"+G74/E74","v":1},{"$f":"IF(K74>G74,K74-G74,0)","v":0},{"$f":"IF(G74>K74,G74-K74,0)","v":0},{"$f":"+R74-S74","v":0.83810606060606063},{"$f":"+I74-T74","v":0},{"$f":"+J74-U74","v":0},21405.119999999999,19264.349999999999]
["LG&E001","410-3158","Reaction Tank Rehabilitation","104012",26015,39586.22,26015,39586.22,0,0,26015,{"$f":"+G75-H75","v":-13571.220000000001},{"$f":"VLOOKUP(B75,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,26015,{"$f":"+G75-Y75","v":0},{"$f":"+H75-Z75","v":325},{"$f":"+H75/F75","v":1},{"$f":"+G75/E75","v":1},{"$f":"IF(K75>G75,K75-G75,0)","v":0},{"$f":"IF(G75>K75,G75-K75,0)","v":0},{"$f":"+R75-S75","v":0},{"$f":"+I75-T75","v":0},{"$f":"+J75-U75","v":0},26015,39261.22]
["MIDADMERICAN","509-2549 REV 2","Replacement Spot Type Heat","104014",22932,15881.46,0,0,0,0,0,{"$f":"+G76-H76","v":0},{"$f":"VLOOKUP(B76,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G76-Y76","v":0},{"$f":"+H76-Z76","v":0},{"$f":"+H76/F76","v":0},{"$f":"+G76/E76","v":0},{"$f":"IF(K76>G76,K76-G76,0)","v":0},{"$f":"IF(G76>K76,G76-K76,0)","v":0},{"$f":"+R76-S76","v":0},{"$f":"+I76-T76","v":0},{"$f":"+J76-U76","v":0},0,0]
["TRISTATE001","410-3375","Fire Protection Audit","104014",21731,4545.18,21731,4545.18,0,0,21731,{"$f":"+G77-H77","v":17185.82},{"$f":"VLOOKUP(B77,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,21731,{"$f":"+G77-Y77","v":17615.150000000001},{"$f":"+H77-Z77","v":1380.17},{"$f":"+H77/F77","v":1},{"$f":"+G77/E77","v":1},{"$f":"IF(K77>G77,K77-G77,0)","v":0},{"$f":"IF(G77>K77,G77-K77,0)","v":0},{"$f":"+R77-S77","v":0},{"$f":"+I77-T77","v":0},{"$f":"+J77-U77","v":0},4115.8500000000004,3165.01]
["TOSHI000020H7EM","2010-01","Tech Training- SW Utilities","105003",18500,13712,18500,7775.29,0,18500,0,{"$f":"+G78-H78","v":10724.71},{"$f":"VLOOKUP(B78,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G78-Y78","v":11024.15},{"$f":"+H78-Z78","v":2234.59},{"$f":"+H78/F78","v":0.56704273628938151},{"$f":"+G78/E78","v":1},{"$f":"IF(K78>G78,K78-G78,0)","v":0},{"$f":"IF(G78>K78,G78-K78,0)","v":18500},{"$f":"+R78-S78","v":-0.43295726371061849},{"$f":"+I78-T78","v":0},{"$f":"+J78-U78","v":0},7475.85,5540.7]
["TOSHI000020H7EM","2010-02","Tech Training - Prairie States","105003",18500,13712,16412.75,7083.05,0,16412.75,0,{"$f":"+G79-H79","v":9329.7000000000007},{"$f":"VLOOKUP(B79,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G79-Y79","v":6950},{"$f":"+H79-Z79","v":69.199999999999818},{"$f":"+H79/F79","v":0.51655848891481915},{"$f":"+G79/E79","v":0.88717567567567568},{"$f":"IF(K79>G79,K79-G79,0)","v":0},{"$f":"IF(G79>K79,G79-K79,0)","v":16412.75},{"$f":"+R79-S79","v":-0.37061718676085653},{"$f":"+I79-T79","v":0},{"$f":"+J79-U79","v":0},9462.75,7013.85]
["TOSHI000020H7EM","2010-05","Tech Training Prairie States","105003",18500,8019.6,4436.3,1923.2,0,4436.3,0,{"$f":"+G80-H80","v":2513.1000000000004},{"$f":"VLOOKUP(B80,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G80-Y80","v":4436.3},{"$f":"+H80-Z80","v":1923.2},{"$f":"+H80/F80","v":0.23981245947428798},{"$f":"+G80/E80","v":0.23980000000000001},{"$f":"IF(K80>G80,K80-G80,0)","v":0},{"$f":"IF(G80>K80,G80-K80,0)","v":4436.3},{"$f":"+R80-S80","v":1.2459474287962458E-5},{"$f":"+I80-T80","v":0},{"$f":"+J80-U80","v":0},0,0]
["MWALLSTAR001","410-3370","Sprinkler System Bldg 4076","304014",15293,10705,0,0,0,0,0,{"$f":"+G81-H81","v":0},{"$f":"VLOOKUP(B81,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G81-Y81","v":0},{"$f":"+H81-Z81","v":0},{"$f":"+H81/F81","v":0},{"$f":"+G81/E81","v":0},{"$f":"IF(K81>G81,K81-G81,0)","v":0},{"$f":"IF(G81>K81,G81-K81,0)","v":0},{"$f":"+R81-S81","v":0},{"$f":"+I81-T81","v":0},{"$f":"+J81-U81","v":0},0,0]
["AMERENUE001","410-3218 GOOSE","Borescope Inspections","104005",13212,7582.1,0,0,0,0,0,{"$f":"+G82-H82","v":0},{"$f":"VLOOKUP(B82,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G82-Y82","v":0},{"$f":"+H82-Z82","v":0},{"$f":"+H82/F82","v":0},{"$f":"+G82/E82","v":0},{"$f":"IF(K82>G82,K82-G82,0)","v":0},{"$f":"IF(G82>K82,G82-K82,0)","v":0},{"$f":"+R82-S82","v":0},{"$f":"+I82-T82","v":0},{"$f":"+J82-U82","v":0},0,0]
["MWALLSTAR001","410-3444","Bldg 1117 Fire Protection","304014",12205,9259,1331.57,1009.8,0,1331.57,0,{"$f":"+G83-H83","v":321.77},{"$f":"VLOOKUP(B83,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G83-Y83","v":0},{"$f":"+H83-Z83","v":0},{"$f":"+H83/F83","v":0.10906145372070418},{"$f":"+G83/E83","v":0.1091003687013519},{"$f":"IF(K83>G83,K83-G83,0)","v":0},{"$f":"IF(G83>K83,G83-K83,0)","v":1331.57},{"$f":"+R83-S83","v":-3.8914980647716813E-5},{"$f":"+I83-T83","v":0},{"$f":"+J83-U83","v":0},1331.57,1009.8]
["JOHNCONTBLD001","FS08-1417 CO","WAFB Boiler #2 Repairs","105004",10391,7000,10391,9056.68,0,0,10391,{"$f":"+G84-H84","v":1334.3199999999997},{"$f":"VLOOKUP(B84,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G84-Y84","v":0},{"$f":"+H84-Z84","v":198.88000000000102},{"$f":"+H84/F84","v":1.2938114285714286},{"$f":"+G84/E84","v":1},{"$f":"IF(K84>G84,K84-G84,0)","v":0},{"$f":"IF(G84>K84,G84-K84,0)","v":0},{"$f":"+R84-S84","v":0.29381142857142861},{"$f":"+I84-T84","v":0},{"$f":"+J84-U84","v":0},10391,8857.7999999999993]
["TOSHI000020H7EM","2010-03","Tech Training-Belledune","105003",10100,7496.4,10100,11824.74,0,10100,0,{"$f":"+G85-H85","v":-1724.7399999999998},{"$f":"VLOOKUP(B85,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G85-Y85","v":0},{"$f":"+H85-Z85","v":2740.92},{"$f":"+H85/F85","v":1.5773891467904595},{"$f":"+G85/E85","v":1},{"$f":"IF(K85>G85,K85-G85,0)","v":0},{"$f":"IF(G85>K85,G85-K85,0)","v":10100},{"$f":"+R85-S85","v":0.5773891467904595},{"$f":"+I85-T85","v":0},{"$f":"+J85-U85","v":0},10100,9083.82]
["AMERENUE001","410-3218 RAC CK","Borescope Inspections","104005",9600,5087.2,0,0,0,0,0,{"$f":"+G86-H86","v":0},{"$f":"VLOOKUP(B86,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G86-Y86","v":0},{"$f":"+H86-Z86","v":0},{"$f":"+H86/F86","v":0},{"$f":"+G86/E86","v":0},{"$f":"IF(K86>G86,K86-G86,0)","v":0},{"$f":"IF(G86>K86,G86-K86,0)","v":0},{"$f":"+R86-S86","v":0},{"$f":"+I86-T86","v":0},{"$f":"+J86-U86","v":0},0,0]
["WATERL001","410-3461","Air Header Installation","104012",9446,7289.6,7169.51,5532.68,2276.4899999999998,0,9446,{"$f":"+G87-H87","v":1636.83},{"$f":"VLOOKUP(B87,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G87-Y87","v":528.97000000000025},{"$f":"+H87-Z87","v":408.48000000000047},{"$f":"+H87/F87","v":0.75898266022827043},{"$f":"+G87/E87","v":0.75899957654033456},{"$f":"IF(K87>G87,K87-G87,0)","v":2276.4899999999998},{"$f":"IF(G87>K87,G87-K87,0)","v":0},{"$f":"+R87-S87","v":-1.6916312064130246E-5},{"$f":"+I87-T87","v":0},{"$f":"+J87-U87","v":0},6640.54,5124.2]
["HAYES001","409-2935","Load Center Cleaning","104013",8730,2144.5,8730,2144.5,0,0,8730,{"$f":"+G88-H88","v":6585.5},{"$f":"VLOOKUP(B88,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,8730,{"$f":"+G88-Y88","v":0},{"$f":"+H88-Z88","v":0},{"$f":"+H88/F88","v":1},{"$f":"+G88/E88","v":1},{"$f":"IF(K88>G88,K88-G88,0)","v":0},{"$f":"IF(G88>K88,G88-K88,0)","v":0},{"$f":"+R88-S88","v":0},{"$f":"+I88-T88","v":0},{"$f":"+J88-U88","v":0},8730,2144.5]
["AMERENUE001","410-3218 KINMUN","Borescope Inspections","104005",6787,3735.9,0,0,0,0,0,{"$f":"+G89-H89","v":0},{"$f":"VLOOKUP(B89,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G89-Y89","v":0},{"$f":"+H89-Z89","v":0},{"$f":"+H89/F89","v":0},{"$f":"+G89/E89","v":0},{"$f":"IF(K89>G89,K89-G89,0)","v":0},{"$f":"IF(G89>K89,G89-K89,0)","v":0},{"$f":"+R89-S89","v":0},{"$f":"+I89-T89","v":0},{"$f":"+J89-U89","v":0},0,0]
["WALDINGER001","409-2951","T9 HVAC WAFB","104013",6212.3,10478.69,6212.3,10478.69,0,0,6212.3,{"$f":"+G90-H90","v":-4266.3900000000003},{"$f":"VLOOKUP(B90,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G90-Y90","v":0},{"$f":"+H90-Z90","v":2413.2400000000007},{"$f":"+H90/F90","v":1},{"$f":"+G90/E90","v":1},{"$f":"IF(K90>G90,K90-G90,0)","v":0},{"$f":"IF(G90>K90,G90-K90,0)","v":0},{"$f":"+R90-S90","v":0},{"$f":"+I90-T90","v":0},{"$f":"+J90-U90","v":0},6212.3,8065.45]
["AMERENUE001","410-3314","Gas Leak Repairs","104005",4000,1172.07,4000,1172.07,0,0,4000,{"$f":"+G91-H91","v":2827.9300000000003},{"$f":"VLOOKUP(B91,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,4000,{"$f":"+G91-Y91","v":0},{"$f":"+H91-Z91","v":0},{"$f":"+H91/F91","v":1},{"$f":"+G91/E91","v":1},{"$f":"IF(K91>G91,K91-G91,0)","v":0},{"$f":"IF(G91>K91,G91-K91,0)","v":0},{"$f":"+R91-S91","v":0},{"$f":"+I91-T91","v":0},{"$f":"+J91-U91","v":0},4000,1172.07]
["DITZFELD001","409-2714","Backflow Test","104014",3767.4,1708.6,3767.4,1708.6,0,0,3767.4,{"$f":"+G92-H92","v":2058.8000000000002},{"$f":"VLOOKUP(B92,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,3767.4,{"$f":"+G92-Y92","v":0},{"$f":"+H92-Z92","v":0},{"$f":"+H92/F92","v":1},{"$f":"+G92/E92","v":1},{"$f":"IF(K92>G92,K92-G92,0)","v":0},{"$f":"IF(G92>K92,G92-K92,0)","v":0},{"$f":"+R92-S92","v":0},{"$f":"+I92-T92","v":0},{"$f":"+J92-U92","v":0},3767.4,1708.6]
["AMERENUE001","410-3251 REV 1","Fire Inspection Raccoon Creek","104014",2890,1605.93,2890,1605.93,0,0,2890,{"$f":"+G93-H93","v":1284.07},{"$f":"VLOOKUP(B93,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,2890,{"$f":"+G93-Y93","v":614.69999999999982},{"$f":"+H93-Z93","v":0},{"$f":"+H93/F93","v":1},{"$f":"+G93/E93","v":1},{"$f":"IF(K93>G93,K93-G93,0)","v":0},{"$f":"IF(G93>K93,G93-K93,0)","v":0},{"$f":"+R93-S93","v":0},{"$f":"+I93-T93","v":0},{"$f":"+J93-U93","v":0},2275.3000000000002,1605.93]
["AMERENUE001","410-3250 REV 1","Fire Inspection Kinmundy","104014",2600,511.49,2600,511.49,0,0,2600,{"$f":"+G94-H94","v":2088.5100000000002},{"$f":"VLOOKUP(B94,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,2600,{"$f":"+G94-Y94","v":1914.6399999999999},{"$f":"+H94-Z94","v":0},{"$f":"+H94/F94","v":1},{"$f":"+G94/E94","v":1},{"$f":"IF(K94>G94,K94-G94,0)","v":0},{"$f":"IF(G94>K94,G94-K94,0)","v":0},{"$f":"+R94-S94","v":0},{"$f":"+I94-T94","v":0},{"$f":"+J94-U94","v":0},685.36,511.49]
["STOVERMILL001","409-2900","Grain Leg Repair","104005",2163,1709.2,136.27000000000001,107.61,0,136.27000000000001,0,{"$f":"+G95-H95","v":28.660000000000011},{"$f":"VLOOKUP(B95,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G95-Y95","v":0},{"$f":"+H95-Z95","v":0},{"$f":"+H95/F95","v":6.2959279194944998E-2},{"$f":"+G95/E95","v":6.3000462320850673E-2},{"$f":"IF(K95>G95,K95-G95,0)","v":0},{"$f":"IF(G95>K95,G95-K95,0)","v":136.27000000000001},{"$f":"+R95-S95","v":-4.1183125905674967E-5},{"$f":"+I95-T95","v":0},{"$f":"+J95-U95","v":0},136.27000000000001,107.61]
["DOGEN001","409-2284","Valve Replacement","104005",1482.47,673,1482.47,673,0,0,1482.47,{"$f":"+G96-H96","v":809.47},{"$f":"VLOOKUP(B96,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G96-Y96","v":0},{"$f":"+H96-Z96","v":0},{"$f":"+H96/F96","v":1},{"$f":"+G96/E96","v":1},{"$f":"IF(K96>G96,K96-G96,0)","v":0},{"$f":"IF(G96>K96,G96-K96,0)","v":0},{"$f":"+R96-S96","v":0},{"$f":"+I96-T96","v":0},{"$f":"+J96-U96","v":0},1482.47,673]
["SUNFL001","FS08-1678-1063","Freezer Lighting","104013",625.97,0,625.97,0,0,0,625.97,{"$f":"+G97-H97","v":625.97},{"$f":"VLOOKUP(B97,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G97-Y97","v":625.97},{"$f":"+H97-Z97","v":0},1,{"$f":"+G97/E97","v":1},{"$f":"IF(K97>G97,K97-G97,0)","v":0},{"$f":"IF(G97>K97,G97-K97,0)","v":0},{"$f":"+R97-S97","v":0},{"$f":"+I97-T97","v":0},{"$f":"+J97-U97","v":0},0,0]
["BELGER001","CS10-0212","Load Stator","104005",324.5,117,324.5,117,0,0,324.5,{"$f":"+G98-H98","v":207.5},{"$f":"VLOOKUP(B98,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G98-Y98","v":324.5},{"$f":"+H98-Z98","v":117},{"$f":"+H98/F98","v":1},{"$f":"+G98/E98","v":1},{"$f":"IF(K98>G98,K98-G98,0)","v":0},{"$f":"IF(G98>K98,G98-K98,0)","v":0},{"$f":"+R98-S98","v":0},{"$f":"+I98-T98","v":0},{"$f":"+J98-U98","v":0},0,0]
["DERWICK001","409-2956","7EA Liquid Fuel Conversion","104002",0,0,0,0,0,0,0,{"$f":"+G99-H99","v":0},{"$f":"VLOOKUP(B99,[1]Projects!$B:$L,11,0)","v":{"$error":"#N/A"}},null,0,{"$f":"+G99-Y99","v":0},{"$f":"+H99-Z99","v":0},0,0,{"$f":"IF(K99>G99,K99-G99,0)","v":0},{"$f":"IF(G99>K99,G99-K99,0)","v":0},{"$f":"+R99-S99","v":0},{"$f":"+I99-T99","v":0},{"$f":"+J99-U99","v":0},0,0]
[null,null,null,null,{"$f":"SUM(E57:E99)","v":1537793.43},{"$f":"SUM(F57:F99)","v":1342450.6499999997},1279315.3900000001,1237401.8799999997,70351.180000000008,172607.13999999998,1177059.43,41913.509999999987,{"$error":"#N/A"},null,943172.85000000009,135168.97,115555.48,33.621531957276503,31.801576505324501,70351.180000000008,172607.13999999998,1.8199554519519989,0,0,1144146.4200000004,1121846.4000000004]

{"sheet":"EPS","index":1,"n_rows":7,"n_cols":24,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received to Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["CORPO001","10-T9002","Termozulia IV",107002,51800000,46620000,16565640,14910369.390000001,{"$f":"K2-G2","v":22284360},0,38850000,{"$f":"G2-H2","v":1655270.6099999994},35172000,3227140,2905017.73,{"$f":"H2/F2","v":0.31982774324324326},{"$f":"G2/E2","v":0.31979999999999997},{"$f":"K2-G2","v":22284360},0,0,0,0,2030560,1826884.67]
["DERWICK001","710-3347","CVG 2 Shipping",107002,6693000,6084545.46,2182587.2999999998,1984217.18,0,2182587.2999999998,0,{"$f":"G3-H3","v":198370.11999999988},0,16742.5,15397.35,{"$f":"H3/F3","v":0.32610770895612634},{"$f":"G3/E3","v":0.32609999999999995},0,2182587.2999999998,0,0,0,2165854.7999999998,1968819.83]
["DERWICK001","710-3150","CVG Shipping",107002,5724950,5204500.5199999996,4806668.0199999996,4369682.5199999996,{"$f":"K4-G4","v":918281.98000000045},0,5724950,{"$f":"G4-H4","v":436985.5},5724950,572.49,520.44000000000005,{"$f":"H4/F4","v":0.83959690333550008},{"$f":"G4/E4","v":0.8395999999999999},{"$f":"K4-G4","v":918281.98000000045},0,0,0,0,59539.48,54103.35]
["CORPO001","10-T9002-Bs","Termozulia IV-In Country",107002,4600000,4883422.78,4600000,7540413.1299999999,0,0,4600000,{"$f":"G5-H5","v":-2940413.13},2300000,0,579553.91,1,{"$f":"G5/E5","v":1},{"$f":"K5-G5","v":0},0,0,0,0,0,1571134.67]
[]
[null,null,"Total Revenue Recognition",null,{"$f":"SUM(E2:E6)","v":68817950},62792468.760000005,28154895.32,28804682.219999999,23202641.98,2182587.2999999998,49174950,-649786.90000000037,43196950,3244454.99,3500489.43]

{"sheet":"Corp OH","index":2,"n_rows":11,"n_cols":24,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received to Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["DERWICK001","410-3280","Curupao (2 7F 2 LM6000) (CVG-C","100001",180000000,162000000,2880000,2590972.83,0,2880000,0,{"$f":"G2-H2","v":289027.16999999993},0,{"$f":"+G2-W2","v":1512000},{"$f":"+H2-X2","v":1363557.6500000001},{"$f":"H2/F2","v":1.5993659444444443E-2},{"$f":"G2/E2","v":1.6E-2},{"$f":"IF(K2>G2,K2-G2,0)","v":0},{"$f":"IF(G2>K2,G2-K2,0)","v":2880000},{"$f":"+P2-Q2","v":-6.3405555555569315E-6},{"$f":"I2-R2","v":0},{"$f":"J2-S2","v":0},1368000,1227415.18]
["DERWICK001","410-3203","CVG Sidor Facility Plant B","100001",79400000,71460000,12362580,11122935.1,27337420,0,39700000,{"$f":"G3-H3","v":1239644.9000000004},23820000,{"$f":"+G3-W3","v":5327740},{"$f":"+H3-X3","v":4793940.3599999994},{"$f":"H3/F3","v":0.15565260425412819},{"$f":"G3/E3","v":0.15570000000000001},{"$f":"IF(K3>G3,K3-G3,0)","v":27337420},{"$f":"IF(G3>K3,G3-K3,0)","v":0},{"$f":"+P3-Q3","v":-4.7395745871814388E-5},{"$f":"I3-R3","v":0},{"$f":"J3-S3","v":0},7034840,6328994.7400000002]
["DERWICK001","410-3202","CVG Sidor Facility Plant A","100001",60177913,53923500,17385399.07,15580072.43,33805263.93,0,51190663,{"$f":"G4-H4","v":1805326.6400000006},17974500,{"$f":"+G4-W4","v":5000968.57},{"$f":"+H4-X4","v":4433886.75},{"$f":"H4/F4","v":0.2889291761476907},{"$f":"G4/E4","v":0.28890000007145478},{"$f":"IF(K4>G4,K4-G4,0)","v":33805263.93},{"$f":"IF(G4>K4,G4-K4,0)","v":0},{"$f":"+P4-Q4","v":2.9176076235926107E-5},{"$f":"I4-R4","v":0},{"$f":"J4-S4","v":0},12384430.5,11146185.68]
["DERWICK001","10-T1004","Jusepin-EPC (4) RR Trent 60","100001",44347000,39912300,1223977.2,1100006.6200000001,0,1223977.2,{"$f":"22173500-22173500","v":0},{"$f":"G5-H5","v":123970.57999999984},0,{"$f":"+G5-W5","v":368803.23},{"$f":"+H5-X5","v":330783.25000000012},{"$f":"H5/F5","v":2.7560592098175251E-2},{"$f":"G5/E5","v":2.76E-2},{"$f":"IF(K5>G5,K5-G5,0)","v":0},{"$f":"IF(G5>K5,G5-K5,0)","v":1223977.2},{"$f":"+P5-Q5","v":-3.9407901824748542E-5},{"$f":"I5-R5","v":0},{"$f":"J5-S5","v":0},855173.97,769223.37]
["EDC001","10-T1009","Guarenas I","100001",36340516.649999999,32706465,6065232.2300000004,5459128.8499999996,8470974.4199999999,0,14536206.65,{"$f":"G6-H6","v":606103.38000000082},0,{"$f":"+G6-W6","v":3274280.5500000003},{"$f":"+H6-X6","v":2948215.3799999994},{"$f":"H6/F6","v":0.16691283665171394},{"$f":"G6/E6","v":0.16690000003068203},{"$f":"IF(K6>G6,K6-G6,0)","v":8470974.4199999999},{"$f":"IF(G6>K6,G6-K6,0)","v":0},{"$f":"+P6-Q6","v":1.2836621031908635E-5},{"$f":"I6-R6","v":0},{"$f":"J6-S6","v":0},2790951.68,2510913.4700000002]
["DERWICK001","10-T9036","LaRaisa II (2 LM6000)","100001",33609000,27000000,414000,373585.49,0,414000,{"$f":"16804500-16804500","v":0},{"$f":"G7-H7","v":40414.510000000009},0,{"$f":"+G7-W7","v":225000},{"$f":"+H7-X7","v":203076.22999999998},{"$f":"H7/F7","v":1.383649962962963E-2},{"$f":"G7/E7","v":1.2318129072569847E-2},{"$f":"IF(K7>G7,K7-G7,0)","v":0},{"$f":"IF(G7>K7,G7-K7,0)","v":414000},{"$f":"+P7-Q7","v":1.5183705570597835E-3},{"$f":"I7-R7","v":0},{"$f":"J7-S7","v":0},189000,170509.26]
["DERWICK001","10-T1003","Barinas (La Fria) (2FT-4TP)","100001",30000000,27000000,1254.0999999999999,1140.0899999999999,0,1254.0999999999999,0,{"$f":"+G8-H8","v":114.00999999999999},0,{"$f":"+G8-W8","v":1254.0999999999999},{"$f":"+H8-X8","v":1140.0899999999999},{"$f":"H8/F8","v":4.2225555555555555E-5},{"$f":"G8/E8","v":4.1803333333333333E-5},{"$f":"IF(K8>G8,K8-G8,0)","v":0},{"$f":"IF(G8>K8,G8-K8,0)","v":1254.0999999999999},{"$f":"+P8-Q8","v":4.2222222222222194E-7},{"$f":"I8-R8","v":0},{"$f":"J8-S8","v":0},0,0]
["DERWICK001","10-T1006","Las Morochas (1) GE LM2500","100001",7975000,7177500,855717.5,770389.54,0,855717.5,{"$f":"4785000-3987500-797500","v":0},{"$f":"G9-H9","v":85327.959999999963},0,{"$f":"+G9-W9","v":540705},{"$f":"+H9-X9","v":486941.63000000006},{"$f":"H9/F9","v":0.10733396586555208},{"$f":"G9/E9","v":0.10730000000000001},{"$f":"IF(K9>G9,K9-G9,0)","v":0},{"$f":"IF(G9>K9,G9-K9,0)","v":855717.5},{"$f":"+P9-Q9","v":3.3965865552071373E-5},{"$f":"I9-R9","v":0},{"$f":"J9-S9","v":0},315012.5,283447.90999999997]
[]
[null,null,"Total Revenue Recognition",null,{"$f":"SUM(E2:E10)","v":471849429.64999998},421179765,41188160.100000001,36998230.950000003,69613658.349999994,5374948.7999999998,105426869.65000001,4189929.1500000013,41794500,16250751.450000001,14561541.34]

{"sheet":"EPC Rev Recog","index":3,"n_rows":6,"n_cols":25,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Signed","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received to Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["EDC001","10-T9018","La Raisa (3) FT8","Yes","100001",33491875,30142687.5,12358501.880000001,11123846.369999999,21133373.120000001,0,33491875,{"$f":"+H2-I2","v":1234655.5100000016},18781824.600000001,{"$f":"+H2-X2","v":2836761.8200000003},{"$f":"+I2-Y2","v":2555483.59},{"$f":"+I2/G2","v":0.36903963423964764},{"$f":"+H2/F2","v":0.36900000014928996},{"$f":"IF(L2>H2,L2-H2,0)","v":21133373.119999997},{"$f":"IF(H2>L2,H2-L2,0)","v":0},{"$f":"+Q2-R2","v":3.9634090357676399E-5},{"$f":"+J2-S2","v":0},{"$f":"+K2-T2","v":0},9521740.0600000005,8568362.7799999993]
["EDC001","10-T9003B","Planta Picure/Tacoa B (2) LM6000s","Yes","100001",20774500,18697050,10586685.199999999,9527993.1300000008,10187814.800000001,0,20774500,{"$f":"+H3-I3","v":1058692.0699999984},19949000,{"$f":"+H3-X3","v":1988119.6499999985},{"$f":"+I3-Y3","v":1788914.1400000006},{"$f":"+I3/G3","v":0.50959874044301112},{"$f":"+H3/F3","v":0.50959999999999994},{"$f":"IF(L3>H3,L3-H3,0)","v":10187814.800000001},{"$f":"IF(H3>L3,H3-L3,0)","v":0},{"$f":"+Q3-R3","v":-1.2595569888196323E-6},{"$f":"+J3-S3","v":0},{"$f":"+K3-T3","v":0},8598565.5500000007,7739078.9900000002]
["EDC001","10-T9003A","Planta Picure/Tacoa A (2) LM2500s","No","100001",14914408.5,13422967.65,10801014.640000001,9720835.8399999999,4113393.86,0,14914408.5,{"$f":"+H4-I4","v":1080178.8000000007},12536000,{"$f":"+H4-X4","v":2392271.1300000008},{"$f":"+I4-Y4","v":2153265.41},{"$f":"+I4/G4","v":0.72419423882020606},{"$f":"+H4/F4","v":0.72420000028831188},{"$f":"IF(L4>H4,L4-H4,0)","v":4113393.8599999994},{"$f":"IF(H4>L4,H4-L4,0)","v":0},{"$f":"+Q4-R4","v":-5.7614681058248962E-6},{"$f":"+J4-S4","v":0},{"$f":"+K4-T4","v":0},8408743.5099999998,7567570.4299999997]
[]
[null,null,"EPC Revenue Recognition",null,null,{"$f":"SUM(F2:F5)","v":69180783.5},62262705.149999999,33746201.719999999,30372675.34,35434581.780000001,0,69180783.5,3373526.3800000008,51266824.600000001,7217152.5999999996,6497663.1400000006]

{"sheet":"FS","index":4,"n_rows":51,"n_cols":24,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received To-Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["GENATL001","EQU08-1222","Equip Sales Agreement - CC","104002",37200000,30000000,37200000,30000000,0,0,37200000,{"$f":"+G2-H2","v":7200000},37107637.909999996,{"$f":"+G2-W2","v":0},{"$f":"+H2-X2","v":0},{"$f":"+H2/F2","v":1},{"$f":"+G2/E2","v":1},{"$f":"IF(K2>G2,K2-G2,0)","v":0},{"$f":"IF(G2>K2,G2-K2,0)","v":0},{"$f":"+P2-Q2","v":0},{"$f":"+I2-R2","v":0},{"$f":"+J2-S2","v":0},37200000,30000000]
["PACIFICRIM002","FS07-0344CABR-1","Cabrutica Installation","804002",17000000,15300000,2834802.62,1981774.53,7340197.3799999999,0,10175000,{"$f":"+G3-H3","v":853028.09000000008},6475000,{"$f":"+G3-W3","v":-100000},{"$f":"+H3-X3","v":197690.12000000011},{"$f":"+H3/F3","v":0.12952774705882353},{"$f":"+G3/E3","v":0.16675309529411766},{"$f":"IF(K3>G3,K3-G3,0)","v":7340197.3799999999},{"$f":"IF(G3>K3,G3-K3,0)","v":0},{"$f":"+P3-Q3","v":-3.7225348235294137E-2},{"$f":"+I3-R3","v":0},{"$f":"+J3-S3","v":0},2934802.62,1784084.41]
["DERWICK001","409-2956-1","Margarita Island Dual Fuel","104002",11263966,10137569.4,251186.44,225738.73,0,251186.44,0,{"$f":"+G4-H4","v":25447.709999999992},0,{"$f":"+G4-W4","v":157695.52000000002},{"$f":"+H4-X4","v":141374.1},{"$f":"+H4/F4","v":2.2267539791145596E-2},{"$f":"+G4/E4","v":2.2299999840198381E-2},{"$f":"IF(K4>G4,K4-G4,0)","v":0},{"$f":"IF(G4>K4,G4-K4,0)","v":251186.44},{"$f":"+P4-Q4","v":-3.2460049052784185E-5},{"$f":"+I4-R4","v":0},{"$f":"+J4-S4","v":0},93490.92,84364.63]
["NATCONTR001","FS08-1678 REV 1","Nat Ctr Aviation - Wichita","104013",5220525,4926101.08,5180332.26,4926101.08,0,390920.07,4789412.1900000004,{"$f":"+G5-H5","v":254231.1799999997},3718649.48,{"$f":"+G5-W5","v":392804.16000000015},{"$f":"+H5-X5","v":392804.16000000015},{"$f":"+H5/F5","v":1},{"$f":"+G5/E5","v":0.99230101570244367},{"$f":"IF(K5>G5,K5-G5,0)","v":0},{"$f":"IF(G5>K5,G5-K5,0)","v":390920.06999999937},{"$f":"+P5-Q5","v":7.6989842975563327E-3},{"$f":"+I5-R5","v":0},{"$f":"+J5-S5","v":6.4028427004814148E-10},4787528.0999999996,4533296.92]
["GENATL001","ENG08-1127 REV1","Engineering Services","104002",3100000,2630000,2945000,2498500,155000,0,3100000,{"$f":"+G6-H6","v":446500},2945000,{"$f":"+G6-W6","v":0},{"$f":"+H6-X6","v":0},{"$f":"+H6/F6","v":0.95},{"$f":"+G6/E6","v":0.95},{"$f":"IF(K6>G6,K6-G6,0)","v":155000},{"$f":"IF(G6>K6,G6-K6,0)","v":0},{"$f":"+P6-Q6","v":0},{"$f":"+I6-R6","v":0},{"$f":"+J6-S6","v":0},2945000,2498500]
["PACIFICRIM001","FS07-0344JOS-1","Josefa Extra Costs","104002",3000000,3000000,1701500,1206655.33,1298500,0,3000000,{"$f":"+G7-H7","v":494844.66999999993},3000000,{"$f":"+G7-W7","v":-100000},{"$f":"+H7-X7","v":5259.9500000001863},{"$f":"+H7/F7","v":0.40221844333333334},{"$f":"+G7/E7","v":0.56716666666666671},{"$f":"IF(K7>G7,K7-G7,0)","v":1298500},{"$f":"IF(G7>K7,G7-K7,0)","v":0},{"$f":"+P7-Q7","v":-0.16494822333333337},{"$f":"+I7-R7","v":0},{"$f":"+J7-S7","v":0},1801500,1201395.3799999999]
["NPPD001","409-2885","Fire Protection Upgrade","104014",2735978,2089047.71,1342544.4,1025166.98,0,330104.59000000003,1012439.81,{"$f":"+G8-H8","v":317377.41999999993},833454.79,{"$f":"+G8-W8","v":191685.91999999993},{"$f":"+H8-X8","v":144025.80999999994},{"$f":"+H8/F8","v":0.49073411540227579},{"$f":"+G8/E8","v":0.49069999831869987},{"$f":"IF(K8>G8,K8-G8,0)","v":0},{"$f":"IF(G8>K8,G8-K8,0)","v":330104.58999999985},{"$f":"+P8-Q8","v":3.4117083575924134E-5},{"$f":"+I8-R8","v":0},{"$f":"+J8-S8","v":0},1150858.48,881141.17]
["WALTONCONST001","409-2513 REV 2","Tinker AFB - Warehouse","104013",2074060,1859561.84,92917.89,83391.8,0,92917.89,0,{"$f":"+G9-H9","v":9526.0899999999965},0,{"$f":"+G9-W9","v":12236.960000000006},{"$f":"+H9-X9","v":11097.130000000005},{"$f":"+H9/F9","v":4.4844865175336139E-2},{"$f":"+G9/E9","v":4.4800000964292257E-2},{"$f":"IF(K9>G9,K9-G9,0)","v":0},{"$f":"IF(G9>K9,G9-K9,0)","v":92917.89},{"$f":"+P9-Q9","v":4.4864211043882385E-5},{"$f":"+I9-R9","v":0},{"$f":"+J9-S9","v":0},80680.929999999993,72294.67]
["VTPUBPOW001","410-3169 REV 1","P10 Generator No 2 Repair","104002",1420000,1194767.6299999999,1420000,1194767.6299999999,0,0,1420000,{"$f":"+G10-H10","v":225232.37000000011},1420000,{"$f":"+G10-W10","v":0},{"$f":"+H10-X10","v":15784.039999999804},{"$f":"+H10/F10","v":1},{"$f":"+G10/E10","v":1},{"$f":"IF(K10>G10,K10-G10,0)","v":0},{"$f":"IF(G10>K10,G10-K10,0)","v":0},{"$f":"+P10-Q10","v":0},{"$f":"+I10-R10","v":0},{"$f":"+J10-S10","v":0},1420000,1178983.5900000001]
["OMPA001","409-2227","Steam Turbine Overhaul","104004",1014356.5,790142.16,955523.82,744290.03,58832.68,0,1014356.5,{"$f":"+G11-H11","v":211233.78999999992},954066.5,{"$f":"+G11-W11","v":4260.2899999999208},{"$f":"+H11-X11","v":3337.8100000000559},{"$f":"+H11/F11","v":0.94196977161679363},{"$f":"+G11/E11","v":0.94199999704245985},{"$f":"IF(K11>G11,K11-G11,0)","v":58832.680000000051},{"$f":"IF(G11>K11,G11-K11,0)","v":0},{"$f":"+P11-Q11","v":-3.022542566621933E-5},{"$f":"+I11-R11","v":0},{"$f":"+J11-S11","v":0},951263.53,740952.22]
["STRAUB001","FS08-1708","City of W'burg PDHQ","104013",499901.66,573107.06000000006,499901.66,573107.06000000006,0,0,499901.66,{"$f":"+G12-H12","v":-73205.400000000081},421755.66,{"$f":"+G12-W12","v":0},{"$f":"+H12-X12","v":1868.1600000000326},{"$f":"+H12/F12","v":1},{"$f":"+G12/E12","v":1},{"$f":"IF(K12>G12,K12-G12,0)","v":0},{"$f":"IF(G12>K12,G12-K12,0)","v":0},{"$f":"+P12-Q12","v":0},{"$f":"+I12-R12","v":0},{"$f":"+J12-S12","v":0},499901.66,571238.9]
["CITYO000020CLEM","410-3110","GE 35 MW Steam Turbine Inspec","104002",238626,185432.34,162361.13,126173.44,0,43048.13,119313,{"$f":"+G13-H13","v":36187.69},0,{"$f":"+G13-W13","v":66051.680000000008},{"$f":"+H13-X13","v":51326.47},{"$f":"+H13/F13","v":0.68042845169294641},{"$f":"+G13/E13","v":0.68039999832373677},{"$f":"IF(K13>G13,K13-G13,0)","v":0},{"$f":"IF(G13>K13,G13-K13,0)","v":43048.130000000005},{"$f":"+P13-Q13","v":2.8453369209646695E-5},{"$f":"+I13-R13","v":0},{"$f":"+J13-S13","v":0},96309.45,74846.97]
["SEPTAG001","409-2302","Sedalia Streetscapes","104013",235226.25,304654.42,235226.25,304654.42,0,0,235226.25,{"$f":"+G14-H14","v":-69428.169999999984},235226.25,{"$f":"+G14-W14","v":0},{"$f":"+H14-X14","v":0},{"$f":"+H14/F14","v":1},{"$f":"+G14/E14","v":1},{"$f":"IF(K14>G14,K14-G14,0)","v":0},{"$f":"IF(G14>K14,G14-K14,0)","v":0},{"$f":"+P14-Q14","v":0},{"$f":"+I14-R14","v":0},{"$f":"+J14-S14","v":0},235226.25,304654.42]
["OG&E001","409-2828 REV 2","HRSG Perforated Plates","104012",211200,187603.20000000001,188728.32000000001,167649.01999999999,22471.68,0,211200,{"$f":"+G15-H15","v":21079.300000000017},211200,{"$f":"+G15-W15","v":21.119999999995343},{"$f":"+H15-X15","v":30},{"$f":"+H15/F15","v":0.89363624927506558},{"$f":"+G15/E15","v":0.89360000000000006},{"$f":"IF(K15>G15,K15-G15,0)","v":22471.679999999993},{"$f":"IF(G15>K15,G15-K15,0)","v":0},{"$f":"+P15-Q15","v":3.6249275065514119E-5},{"$f":"+I15-R15","v":0},{"$f":"+J15-S15","v":0},188707.20000000001,167619.01999999999]
["OMU001","409-2659","Air Heater Basket Replacement","104012",199440,100991.05,199440,100991.05,0,0,199440,{"$f":"+G16-H16","v":98448.95},199440,{"$f":"+G16-W16","v":0},{"$f":"+H16-X16","v":0},{"$f":"+H16/F16","v":1},{"$f":"+G16/E16","v":1},{"$f":"IF(K16>G16,K16-G16,0)","v":0},{"$f":"IF(G16>K16,G16-K16,0)","v":0},{"$f":"+P16-Q16","v":0},{"$f":"+I16-R16","v":0},{"$f":"+J16-S16","v":0},199440,100991.05]
["CITYOFSP001","410-3163","Steam Drum Internals Repl","104012",195575.63,145648.17000000001,182902.33,136205.95000000001,12673.3,0,195575.63,{"$f":"+G17-H17","v":46696.379999999976},195575.63,{"$f":"+G17-W17","v":1193.0099999999802},{"$f":"+H17-X17","v":885.72000000000116},{"$f":"+H17/F17","v":0.93517103579124961},{"$f":"+G17/E17","v":0.93520000421320382},{"$f":"IF(K17>G17,K17-G17,0)","v":12673.300000000017},{"$f":"IF(G17>K17,G17-K17,0)","v":0},{"$f":"+P17-Q17","v":-2.8968421954211898E-5},{"$f":"+I17-R17","v":-1.8189894035458565E-11},{"$f":"+J17-S17","v":0},181709.32,135320.23000000001]
["MWALLSTAR001","409-2764 REV 1","HS 3030 Network Fire Alarm","104014",140000,107597.73,140000,107597.73,0,0,140000,{"$f":"+G18-H18","v":32402.270000000004},126000,{"$f":"+G18-W18","v":0},{"$f":"+H18-X18","v":0},{"$f":"+H18/F18","v":1},{"$f":"+G18/E18","v":1},{"$f":"IF(K18>G18,K18-G18,0)","v":0},{"$f":"IF(G18>K18,G18-K18,0)","v":0},{"$f":"+P18-Q18","v":0},{"$f":"+I18-R18","v":0},{"$f":"+J18-S18","v":0},140000,107597.73]
["COIL001","FS08-1124 REV4","PW Facility Warrensburg, MO","104005",130782,276284.15000000002,130782,276284.15000000002,0,0,130782,{"$f":"+G19-H19","v":-145502.15000000002},117703.8,{"$f":"+G19-W19","v":0},{"$f":"+H19-X19","v":0},{"$f":"+H19/F19","v":1},{"$f":"+G19/E19","v":1},{"$f":"IF(K19>G19,K19-G19,0)","v":0},{"$f":"IF(G19>K19,G19-K19,0)","v":0},{"$f":"+P19-Q19","v":0},{"$f":"+I19-R19","v":0},{"$f":"+J19-S19","v":0},130782,276284.15000000002]
["CALEN000020HWEM","409-2942 REV 1","CI & Alignment Steam Turbine","104002",112092,103385.64,112092,103385.64,0,0,112092,{"$f":"+G20-H20","v":8706.36},12692,{"$f":"+G20-W20","v":0},{"$f":"+H20-X20","v":0},{"$f":"+H20/F20","v":1},{"$f":"+G20/E20","v":1},{"$f":"IF(K20>G20,K20-G20,0)","v":0},{"$f":"IF(G20>K20,G20-K20,0)","v":0},{"$f":"+P20-Q20","v":0},{"$f":"+I20-R20","v":0},{"$f":"+J20-S20","v":0},112092,103385.64]
["CITYO000020CLEM","410-3110 EW01","Steam Turbine Overhaul","104002",95940,79950,47970,39975,0,47970,0,{"$f":"+G21-H21","v":7995},0,{"$f":"+G21-W21","v":47970},{"$f":"+H21-X21","v":39975},{"$f":"+H21/F21","v":0.5},{"$f":"+G21/E21","v":0.5},{"$f":"IF(K21>G21,K21-G21,0)","v":0},{"$f":"IF(G21>K21,G21-K21,0)","v":47970},{"$f":"+P21-Q21","v":0},{"$f":"+I21-R21","v":0},{"$f":"+J21-S21","v":0},0,0]
["MWALLSTAR001","409-2843 REV 3","WAFB T-9","104013",72318,60404.65,56914.27,47535.33,15403.73,0,72318,{"$f":"+G22-H22","v":9378.9399999999951},0,{"$f":"+G22-W22","v":1366.8099999999977},{"$f":"+H22-X22","v":1136.0600000000049},{"$f":"+H22/F22","v":0.78694819024694296},{"$f":"+G22/E22","v":0.78700005531126405},{"$f":"IF(K22>G22,K22-G22,0)","v":15403.730000000003},{"$f":"IF(G22>K22,G22-K22,0)","v":0},{"$f":"+P22-Q22","v":-5.1865064321088283E-5},{"$f":"+I22-R22","v":0},{"$f":"+J22-S22","v":0},55547.46,46399.27]
["VICWLE001","409-2958","Steam Valve Inspection","104002",67055,50374.97,67055,50374.97,0,0,67055,{"$f":"+G23-H23","v":16680.03},67055,{"$f":"+G23-W23","v":0},{"$f":"+H23-X23","v":0},{"$f":"+H23/F23","v":1},{"$f":"+G23/E23","v":1},{"$f":"IF(K23>G23,K23-G23,0)","v":0},{"$f":"IF(G23>K23,G23-K23,0)","v":0},{"$f":"+P23-Q23","v":0},{"$f":"+I23-R23","v":0},{"$f":"+J23-S23","v":0},67055,50374.97]
["SEPTAG001","409-2847","Biosolids Composting Facility","104013",46754,40671.129999999997,45468.27,39554.44,0,28007.27,17461,{"$f":"+G24-H24","v":5913.8299999999945},15714.9,{"$f":"+G24-W24","v":18364.979999999996},{"$f":"+H24-X24","v":15977.670000000002},{"$f":"+H24/F24","v":0.97254342330788457},{"$f":"+G24/E24","v":0.97250010694272138},{"$f":"IF(K24>G24,K24-G24,0)","v":0},{"$f":"IF(G24>K24,G24-K24,0)","v":28007.269999999997},{"$f":"+P24-Q24","v":4.3316365163192927E-5},{"$f":"+I24-R24","v":0},{"$f":"+J24-S24","v":0},27103.29,23576.77]
["MWALLSTAR001","409-2844 REV 1","Upgrade Dormitory Campus","104013",45320,39411.14,16981.400000000001,14768.09,0,16981.400000000001,0,{"$f":"+G25-H25","v":2213.3100000000013},0,{"$f":"+G25-W25","v":58.909999999999854},{"$f":"+H25-X25","v":52.8700000000008},{"$f":"+H25/F25","v":0.37471867091385835},{"$f":"+G25/E25","v":0.37469991173874673},{"$f":"IF(K25>G25,K25-G25,0)","v":0},{"$f":"IF(G25>K25,G25-K25,0)","v":16981.400000000001},{"$f":"+P25-Q25","v":1.8759175111626725E-5},{"$f":"+I25-R25","v":0},{"$f":"+J25-S25","v":0},16922.490000000002,14715.22]
["TRISTATE001","410-3219","Exhaust Welding","104005",42825,17394.509999999998,42825,17394.509999999998,0,0,42825,{"$f":"+G26-H26","v":25430.49},42825,{"$f":"+G26-W26","v":0},{"$f":"+H26-X26","v":66.709999999999127},{"$f":"+H26/F26","v":1},{"$f":"+G26/E26","v":1},{"$f":"IF(K26>G26,K26-G26,0)","v":0},{"$f":"IF(G26>K26,G26-K26,0)","v":0},{"$f":"+P26-Q26","v":0},{"$f":"+I26-R26","v":0},{"$f":"+J26-S26","v":0},42825,17327.8]
["KCPL001","410-3223","Transformer Fire Protection","104014",40905,29692.21,40905,29692.21,0,0,40905,{"$f":"+G27-H27","v":11212.79},40905,{"$f":"+G27-W27","v":355.87000000000262},{"$f":"+H27-X27","v":1491.5400000000009},{"$f":"+H27/F27","v":1},{"$f":"+G27/E27","v":1},{"$f":"IF(K27>G27,K27-G27,0)","v":0},{"$f":"IF(G27>K27,G27-K27,0)","v":0},{"$f":"+P27-Q27","v":0},{"$f":"+I27-R27","v":0},{"$f":"+J27-S27","v":0},40549.129999999997,28200.67]
["CITYSEDALIA001","409-3107","Liberty Park","104013",26475,21118.38,22043.09,17583.990000000002,0,863.09,21180,{"$f":"+G28-H28","v":4459.0999999999985},19062,{"$f":"+G28-W28","v":0},{"$f":"+H28-X28","v":0},{"$f":"+H28/F28","v":0.83263915129853716},{"$f":"+G28/E28","v":0.8326001888574126},{"$f":"IF(K28>G28,K28-G28,0)","v":0},{"$f":"IF(G28>K28,G28-K28,0)","v":863.09000000000015},{"$f":"+P28-Q28","v":3.8962441124557046E-5},{"$f":"+I28-R28","v":0},{"$f":"+J28-S28","v":0},22043.09,17583.990000000002]
["MCCONEX001","409-2732","Traffic Signal Work","104013",26419,23625.47,17193.490000000002,15375.78,0,17193.490000000002,0,{"$f":"+G29-H29","v":1817.7100000000009},0,{"$f":"+G29-W29","v":3241.6200000000008},{"$f":"+H29-X29","v":2900.3700000000008},{"$f":"+H29/F29","v":0.65081371926145803},{"$f":"+G29/E29","v":0.65080018168742204},{"$f":"IF(K29>G29,K29-G29,0)","v":0},{"$f":"IF(G29>K29,G29-K29,0)","v":17193.490000000002},{"$f":"+P29-Q29","v":1.3537574035993316E-5},{"$f":"+I29-R29","v":0},{"$f":"+J29-S29","v":0},13951.87,12475.41]
["LG&E001","410-3158","Reaction Tank Rehabilitation","104012",26015,39586.22,26015,39586.22,0,0,26015,{"$f":"+G30-H30","v":-13571.220000000001},26015,{"$f":"+G30-W30","v":0},{"$f":"+H30-X30","v":325},{"$f":"+H30/F30","v":1},{"$f":"+G30/E30","v":1},{"$f":"IF(K30>G30,K30-G30,0)","v":0},{"$f":"IF(G30>K30,G30-K30,0)","v":0},{"$f":"+P30-Q30","v":0},{"$f":"+I30-R30","v":0},{"$f":"+J30-S30","v":0},26015,39261.22]
["MIDADMERICAN","509-2549 REV 2","Replacement Spot Type Heat","104014",22932,15881.46,0,0,0,0,0,{"$f":"+G31-H31","v":0},0,{"$f":"+G31-W31","v":0},{"$f":"+H31-X31","v":0},{"$f":"+H31/F31","v":0},{"$f":"+G31/E31","v":0},{"$f":"IF(K31>G31,K31-G31,0)","v":0},{"$f":"IF(G31>K31,G31-K31,0)","v":0},{"$f":"+P31-Q31","v":0},{"$f":"+I31-R31","v":0},{"$f":"+J31-S31","v":0},0,0]
["TRISTATE001","410-3375","Fire Protection Audit","104014",21731,4545.18,21731,4545.18,0,0,21731,{"$f":"+G32-H32","v":17185.82},21731,{"$f":"+G32-W32","v":17615.150000000001},{"$f":"+H32-X32","v":1380.17},{"$f":"+H32/F32","v":1},{"$f":"+G32/E32","v":1},{"$f":"IF(K32>G32,K32-G32,0)","v":0},{"$f":"IF(G32>K32,G32-K32,0)","v":0},{"$f":"+P32-Q32","v":0},{"$f":"+I32-R32","v":0},{"$f":"+J32-S32","v":0},4115.8500000000004,3165.01]
["MWALLSTAR001","410-3370","Sprinkler System Bldg 4076","304014",15293,10705,0,0,0,0,0,{"$f":"+G33-H33","v":0},0,{"$f":"+G33-W33","v":0},{"$f":"+H33-X33","v":0},{"$f":"+H33/F33","v":0},{"$f":"+G33/E33","v":0},{"$f":"IF(K33>G33,K33-G33,0)","v":0},{"$f":"IF(G33>K33,G33-K33,0)","v":0},{"$f":"+P33-Q33","v":0},{"$f":"+I33-R33","v":0},{"$f":"+J33-S33","v":0},0,0]
["AMERENUE001","410-3218 GOOSE","Borescope Inspections","104005",13212,7582.1,0,0,0,0,0,{"$f":"+G34-H34","v":0},0,{"$f":"+G34-W34","v":0},{"$f":"+H34-X34","v":0},{"$f":"+H34/F34","v":0},{"$f":"+G34/E34","v":0},{"$f":"IF(K34>G34,K34-G34,0)","v":0},{"$f":"IF(G34>K34,G34-K34,0)","v":0},{"$f":"+P34-Q34","v":0},{"$f":"+I34-R34","v":0},{"$f":"+J34-S34","v":0},0,0]
["MWALLSTAR001","410-3444","Bldg 1117 Fire Protection","304014",12205,9259,1331.57,1009.8,0,1331.57,0,{"$f":"+G35-H35","v":321.77},0,{"$f":"+G35-W35","v":0},{"$f":"+H35-X35","v":0},{"$f":"+H35/F35","v":0.10906145372070418},{"$f":"+G35/E35","v":0.1091003687013519},{"$f":"IF(K35>G35,K35-G35,0)","v":0},{"$f":"IF(G35>K35,G35-K35,0)","v":1331.57},{"$f":"+P35-Q35","v":-3.8914980647716813E-5},{"$f":"+I35-R35","v":0},{"$f":"+J35-S35","v":0},1331.57,1009.8]
["AMERENUE001","410-3218 RAC CK","Borescope Inspections","104005",9600,5087.2,0,0,0,0,0,{"$f":"+G36-H36","v":0},0,{"$f":"+G36-W36","v":0},{"$f":"+H36-X36","v":0},{"$f":"+H36/F36","v":0},{"$f":"+G36/E36","v":0},{"$f":"IF(K36>G36,K36-G36,0)","v":0},{"$f":"IF(G36>K36,G36-K36,0)","v":0},{"$f":"+P36-Q36","v":0},{"$f":"+I36-R36","v":0},{"$f":"+J36-S36","v":0},0,0]
["WATERL001","410-3461","Air Header Installation","104012",9446,7289.6,7169.51,5532.68,2276.4899999999998,0,9446,{"$f":"+G37-H37","v":1636.83},0,{"$f":"+G37-W37","v":528.97000000000025},{"$f":"+H37-X37","v":408.48000000000047},{"$f":"+H37/F37","v":0.75898266022827043},{"$f":"+G37/E37","v":0.75899957654033456},{"$f":"IF(K37>G37,K37-G37,0)","v":2276.4899999999998},{"$f":"IF(G37>K37,G37-K37,0)","v":0},{"$f":"+P37-Q37","v":-1.6916312064130246E-5},{"$f":"+I37-R37","v":0},{"$f":"+J37-S37","v":0},6640.54,5124.2]
["HAYES001","409-2935","Load Center Cleaning","104013",8730,2144.5,8730,2144.5,0,0,8730,{"$f":"+G38-H38","v":6585.5},8730,{"$f":"+G38-W38","v":0},{"$f":"+H38-X38","v":0},{"$f":"+H38/F38","v":1},{"$f":"+G38/E38","v":1},{"$f":"IF(K38>G38,K38-G38,0)","v":0},{"$f":"IF(G38>K38,G38-K38,0)","v":0},{"$f":"+P38-Q38","v":0},{"$f":"+I38-R38","v":0},{"$f":"+J38-S38","v":0},8730,2144.5]
["AMERENUE001","410-3218 KINMUN","Borescope Inspections","104005",6787,3735.9,0,0,0,0,0,{"$f":"+G39-H39","v":0},0,{"$f":"+G39-W39","v":0},{"$f":"+H39-X39","v":0},{"$f":"+H39/F39","v":0},{"$f":"+G39/E39","v":0},{"$f":"IF(K39>G39,K39-G39,0)","v":0},{"$f":"IF(G39>K39,G39-K39,0)","v":0},{"$f":"+P39-Q39","v":0},{"$f":"+I39-R39","v":0},{"$f":"+J39-S39","v":0},0,0]
["WALDINGER001","409-2951","T9 HVAC WAFB","104013",6212.3,10478.69,6212.3,10478.69,0,0,6212.3,{"$f":"+G40-H40","v":-4266.3900000000003},0,{"$f":"+G40-W40","v":0},{"$f":"+H40-X40","v":2413.2400000000007},{"$f":"+H40/F40","v":1},{"$f":"+G40/E40","v":1},{"$f":"IF(K40>G40,K40-G40,0)","v":0},{"$f":"IF(G40>K40,G40-K40,0)","v":0},{"$f":"+P40-Q40","v":0},{"$f":"+I40-R40","v":0},{"$f":"+J40-S40","v":0},6212.3,8065.45]
["AMERENUE001","410-3314","Gas Leak Repairs","104005",4000,1172.07,4000,1172.07,0,0,4000,{"$f":"+G41-H41","v":2827.9300000000003},4000,{"$f":"+G41-W41","v":0},{"$f":"+H41-X41","v":0},{"$f":"+H41/F41","v":1},{"$f":"+G41/E41","v":1},{"$f":"IF(K41>G41,K41-G41,0)","v":0},{"$f":"IF(G41>K41,G41-K41,0)","v":0},{"$f":"+P41-Q41","v":0},{"$f":"+I41-R41","v":0},{"$f":"+J41-S41","v":0},4000,1172.07]
["DITZFELD001","409-2714","Backflow Test","104014",3767.4,1708.6,3767.4,1708.6,0,0,3767.4,{"$f":"+G42-H42","v":2058.8000000000002},3767.4,{"$f":"+G42-W42","v":0},{"$f":"+H42-X42","v":0},{"$f":"+H42/F42","v":1},{"$f":"+G42/E42","v":1},{"$f":"IF(K42>G42,K42-G42,0)","v":0},{"$f":"IF(G42>K42,G42-K42,0)","v":0},{"$f":"+P42-Q42","v":0},{"$f":"+I42-R42","v":0},{"$f":"+J42-S42","v":0},3767.4,1708.6]
["AMERENUE001","410-3251 REV 1","Fire Inspection Raccoon Creek","104014",2890,1605.93,2890,1605.93,0,0,2890,{"$f":"+G43-H43","v":1284.07},2890,{"$f":"+G43-W43","v":614.69999999999982},{"$f":"+H43-X43","v":0},{"$f":"+H43/F43","v":1},{"$f":"+G43/E43","v":1},{"$f":"IF(K43>G43,K43-G43,0)","v":0},{"$f":"IF(G43>K43,G43-K43,0)","v":0},{"$f":"+P43-Q43","v":0},{"$f":"+I43-R43","v":0},{"$f":"+J43-S43","v":0},2275.3000000000002,1605.93]
["AMERENUE001","410-3250 REV 1","Fire Inspection Kinmundy","104014",2600,511.49,2600,511.49,0,0,2600,{"$f":"+G44-H44","v":2088.5100000000002},2600,{"$f":"+G44-W44","v":1914.6399999999999},{"$f":"+H44-X44","v":0},{"$f":"+H44/F44","v":1},{"$f":"+G44/E44","v":1},{"$f":"IF(K44>G44,K44-G44,0)","v":0},{"$f":"IF(G44>K44,G44-K44,0)","v":0},{"$f":"+P44-Q44","v":0},{"$f":"+I44-R44","v":0},{"$f":"+J44-S44","v":0},685.36,511.49]
["STOVERMILL001","409-2900","Grain Leg Repair","104005",2163,1709.2,136.27000000000001,107.61,0,136.27000000000001,0,{"$f":"+G45-H45","v":28.660000000000011},0,{"$f":"+G45-W45","v":0},{"$f":"+H45-X45","v":0},{"$f":"+H45/F45","v":6.2959279194944998E-2},{"$f":"+G45/E45","v":6.3000462320850673E-2},{"$f":"IF(K45>G45,K45-G45,0)","v":0},{"$f":"IF(G45>K45,G45-K45,0)","v":136.27000000000001},{"$f":"+P45-Q45","v":-4.1183125905674967E-5},{"$f":"+I45-R45","v":0},{"$f":"+J45-S45","v":0},136.27000000000001,107.61]
["DOGEN001","409-2284","Valve Replacement","104005",1482.47,673,1482.47,673,0,0,1482.47,{"$f":"+G46-H46","v":809.47},0,{"$f":"+G46-W46","v":0},{"$f":"+H46-X46","v":0},{"$f":"+H46/F46","v":1},{"$f":"+G46/E46","v":1},{"$f":"IF(K46>G46,K46-G46,0)","v":0},{"$f":"IF(G46>K46,G46-K46,0)","v":0},{"$f":"+P46-Q46","v":0},{"$f":"+I46-R46","v":0},{"$f":"+J46-S46","v":0},1482.47,673]
["SUNFL001","FS08-1678-1063","Freezer Lighting","104013",625.97,0,625.97,0,0,0,625.97,{"$f":"+G47-H47","v":625.97},0,{"$f":"+G47-W47","v":625.97},{"$f":"+H47-X47","v":0},1,{"$f":"+G47/E47","v":1},{"$f":"IF(K47>G47,K47-G47,0)","v":0},{"$f":"IF(G47>K47,G47-K47,0)","v":0},{"$f":"+P47-Q47","v":0},{"$f":"+I47-R47","v":0},{"$f":"+J47-S47","v":0},0,0]
["BELGER001","CS10-0212","Load Stator","104005",324.5,117,324.5,117,0,0,324.5,{"$f":"+G48-H48","v":207.5},0,{"$f":"+G48-W48","v":324.5},{"$f":"+H48-X48","v":117},{"$f":"+H48/F48","v":1},{"$f":"+G48/E48","v":1},{"$f":"IF(K48>G48,K48-G48,0)","v":0},{"$f":"IF(G48>K48,G48-K48,0)","v":0},{"$f":"+P48-Q48","v":0},{"$f":"+I48-R48","v":0},{"$f":"+J48-S48","v":0},0,0]
["DERWICK001","409-2956","7EA Liquid Fuel Conversion","104002",0,0,0,0,0,0,0,{"$f":"+G49-H49","v":0},0,{"$f":"+G49-W49","v":0},{"$f":"+H49-X49","v":0},0,0,{"$f":"IF(K49>G49,K49-G49,0)","v":0},{"$f":"IF(G49>K49,G49-K49,0)","v":0},{"$f":"+P49-Q49","v":0},{"$f":"+I49-R49","v":0},{"$f":"+J49-S49","v":0},0,0]
[]
[null,null,"Total Revenue Recognition",null,{"$f":"SUM(E2:E50)","v":86625756.679999992},{"$f":"SUM(F2:F50)","v":74398328.179999992},56219612.629999995,46123881.659999996,8905355.2599999998,1220660.21,63904307.679999992,10095730.969999999,58228697.319999985,718930.77999999991,1031727.5800000003,33.539464767309568,33.733921628465922]

{"sheet":"TS","index":5,"n_rows":15,"n_cols":24,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received To-Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["INOTEC001","110-3353 MOB","Angola Mobilization","105009",1098394,878715,8128.12,6526.82,0,8128.12,0,{"$f":"+G2-H2","v":1601.3000000000002},0,{"$f":"+G2-W2","v":8128.12},{"$f":"+H2-X2","v":6526.82},{"$f":"+H2/F2","v":7.4276870202511615E-3},{"$f":"+G2/E2","v":7.4000040058485386E-3},{"$f":"IF(K2>G2,K2-G2,0)","v":0},{"$f":"IF(G2>K2,G2-K2,0)","v":8128.12},{"$f":"+P2-Q2","v":2.7683014402622892E-5},{"$f":"+I2-R2","v":0},{"$f":"+J2-S2","v":0},0,0]
["PROEPC001","109-2317 MOB","Naudero Mobilization","105009",900000,765000,620190,527155.26,279810,0,900000,{"$f":"+G3-H3","v":93034.739999999991},877720.12,{"$f":"+G3-W3","v":144630},{"$f":"+H3-X3","v":122898.5},{"$f":"+H3/F3","v":0.68909184313725491},{"$f":"+G3/E3","v":0.68910000000000005},{"$f":"IF(K3>G3,K3-G3,0)","v":279810},{"$f":"IF(G3>K3,G3-K3,0)","v":0},{"$f":"+P3-Q3","v":-8.1568627451344966E-6},{"$f":"+I3-R3","v":0},{"$f":"+J3-S3","v":0},475560,404256.76]
["JOHNCONTBLD001","FS08-1422 REV4","Central Heating Contrl Upgrade","105004",862750,614815.46,469594.83,334619.40999999997,0,340182.33,129412.5,{"$f":"+G4-H4","v":134975.42000000004},129412.5,{"$f":"+G4-W4","v":271852.53000000003},{"$f":"+H4-X4","v":193731.92999999996},{"$f":"+H4/F4","v":0.54425991499953497},{"$f":"+G4/E4","v":0.54430000579542159},{"$f":"IF(K4>G4,K4-G4,0)","v":0},{"$f":"IF(G4>K4,G4-K4,0)","v":340182.33},{"$f":"+P4-Q4","v":-4.0090795886627006E-5},{"$f":"+I4-R4","v":0},{"$f":"+J4-S4","v":0},197742.3,140887.48000000001]
["EPS001","510-3156","ABB Backup Generator Repair","105008",140793.79,116000,88122.83,72600.08,52670.96,0,140793.79,{"$f":"+G5-H5","v":15522.75},140793.79,{"$f":"+G5-W5","v":14781.520000000004},{"$f":"+H5-X5","v":16298.61},{"$f":"+H5/F5","v":0.62586275862068963},{"$f":"+G5/E5","v":0.62589997754872562},{"$f":"IF(K5>G5,K5-G5,0)","v":52670.960000000006},{"$f":"IF(G5>K5,G5-K5,0)","v":0},{"$f":"+P5-Q5","v":-3.721892803598692E-5},{"$f":"+I5-R5","v":0},{"$f":"+J5-S5","v":0},73341.31,56301.47]
["EMERS001","FS08-1251 REV 2","Mark V Engr Lead","105004",106750,73040,106750,161048.59,0,10675,96075,{"$f":"+G6-H6","v":-54298.59},96075,{"$f":"+G6-W6","v":0},{"$f":"+H6-X6","v":0},{"$f":"+H6/F6","v":2.2049368838992334},{"$f":"+G6/E6","v":1},{"$f":"IF(K6>G6,K6-G6,0)","v":0},{"$f":"IF(G6>K6,G6-K6,0)","v":10675},{"$f":"+P6-Q6","v":1.2049368838992334},{"$f":"+I6-R6","v":0},{"$f":"+J6-S6","v":0},106750,161048.59]
["TOSHAMER001","2009-05","Technical Training - Whelan","105003",30000,13875,30000,11955.15,0,0,30000,{"$f":"+G7-H7","v":18044.849999999999},30000,{"$f":"+G7-W7","v":0},{"$f":"+H7-X7","v":0},{"$f":"+H7/F7","v":0.86163243243243237},{"$f":"+G7/E7","v":1},{"$f":"IF(K7>G7,K7-G7,0)","v":0},{"$f":"IF(G7>K7,G7-K7,0)","v":0},{"$f":"+P7-Q7","v":-0.13836756756756763},{"$f":"+I7-R7","v":0},{"$f":"+J7-S7","v":0},30000,11955.15]
["AMERENUE001","109-2899 MOB","June'10 Ameren Mobilization","105009",26400,23760,26400,43673.4,0,0,26400,{"$f":"+G8-H8","v":-17273.400000000001},26400,{"$f":"+G8-W8","v":4994.880000000001},{"$f":"+H8-X8","v":24409.050000000003},{"$f":"+H8/F8","v":1.8381060606060606},{"$f":"+G8/E8","v":1},{"$f":"IF(K8>G8,K8-G8,0)","v":0},{"$f":"IF(G8>K8,G8-K8,0)","v":0},{"$f":"+P8-Q8","v":0.83810606060606063},{"$f":"+I8-R8","v":0},{"$f":"+J8-S8","v":0},21405.119999999999,19264.349999999999]
["TOSHI000020H7EM","2010-01","Tech Training- SW Utilities","105003",18500,13712,18500,7775.29,0,18500,0,{"$f":"+G9-H9","v":10724.71},0,{"$f":"+G9-W9","v":11024.15},{"$f":"+H9-X9","v":2234.59},{"$f":"+H9/F9","v":0.56704273628938151},{"$f":"+G9/E9","v":1},{"$f":"IF(K9>G9,K9-G9,0)","v":0},{"$f":"IF(G9>K9,G9-K9,0)","v":18500},{"$f":"+P9-Q9","v":-0.43295726371061849},{"$f":"+I9-R9","v":0},{"$f":"+J9-S9","v":0},7475.85,5540.7]
["TOSHI000020H7EM","2010-02","Tech Training - Prairie States","105003",18500,13712,16412.75,7083.05,0,16412.75,0,{"$f":"+G10-H10","v":9329.7000000000007},0,{"$f":"+G10-W10","v":6950},{"$f":"+H10-X10","v":69.199999999999818},{"$f":"+H10/F10","v":0.51655848891481915},{"$f":"+G10/E10","v":0.88717567567567568},{"$f":"IF(K10>G10,K10-G10,0)","v":0},{"$f":"IF(G10>K10,G10-K10,0)","v":16412.75},{"$f":"+P10-Q10","v":-0.37061718676085653},{"$f":"+I10-R10","v":0},{"$f":"+J10-S10","v":0},9462.75,7013.85]
["TOSHI000020H7EM","2010-05","Tech Training Prairie States","105003",18500,8019.6,4436.3,1923.2,0,4436.3,0,{"$f":"+G11-H11","v":2513.1000000000004},0,{"$f":"+G11-W11","v":4436.3},{"$f":"+H11-X11","v":1923.2},{"$f":"+H11/F11","v":0.23981245947428798},{"$f":"+G11/E11","v":0.23980000000000001},{"$f":"IF(K11>G11,K11-G11,0)","v":0},{"$f":"IF(G11>K11,G11-K11,0)","v":4436.3},{"$f":"+P11-Q11","v":1.2459474287962458E-5},{"$f":"+I11-R11","v":0},{"$f":"+J11-S11","v":0},0,0]
["JOHNCONTBLD001","FS08-1417 CO","WAFB Boiler #2 Repairs","105004",10391,7000,10391,9056.68,0,0,10391,{"$f":"+G12-H12","v":1334.3199999999997},0,{"$f":"+G12-W12","v":0},{"$f":"+H12-X12","v":198.88000000000102},{"$f":"+H12/F12","v":1.2938114285714286},{"$f":"+G12/E12","v":1},{"$f":"IF(K12>G12,K12-G12,0)","v":0},{"$f":"IF(G12>K12,G12-K12,0)","v":0},{"$f":"+P12-Q12","v":0.29381142857142861},{"$f":"+I12-R12","v":0},{"$f":"+J12-S12","v":0},10391,8857.7999999999993]
["TOSHI000020H7EM","2010-03","Tech Training-Belledune","105003",10100,7496.4,10100,11824.74,0,10100,0,{"$f":"+G13-H13","v":-1724.7399999999998},0,{"$f":"+G13-W13","v":0},{"$f":"+H13-X13","v":2740.92},{"$f":"+H13/F13","v":1.5773891467904595},{"$f":"+G13/E13","v":1},{"$f":"IF(K13>G13,K13-G13,0)","v":0},{"$f":"IF(G13>K13,G13-K13,0)","v":10100},{"$f":"+P13-Q13","v":0.5773891467904595},{"$f":"+I13-R13","v":0},{"$f":"+J13-S13","v":0},10100,9083.82]
[]
[null,null,"Total Revenue Recognition",null,{"$f":"SUM(E2:E14)","v":3241078.79},{"$f":"SUM(F2:F14)","v":2535145.46},1409025.83,1195241.6699999997,332480.96000000002,408434.5,1333072.29,213784.16000000006,1300401.4099999999,466797.50000000006,371031.7,10.965931840755834]

{"sheet":"O&M Rev Recg","index":6,"n_rows":16,"n_cols":24,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received To-Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["EMGASUD001","OM08-1239 O&M-M","Matheu O&M","101160",2516697,1798502.01,1639380,1171546,392587,0,2031967,{"$f":"+G2-H2","v":467834},1896408,{"$f":"+G2-X2","v":547220},{"$f":"+H2-Y2","v":1171546},{"$f":"+H2/F2","v":0.65140099565415555},{"$f":"+G2/E2","v":0.65140142019480296},{"$f":"IF(K2>G2,K2-G2,0)","v":392587},{"$f":"IF(G2>K2,G2-K2,0)","v":0},{"$f":"+P2-Q2","v":-4.2454064741459518E-7},{"$f":"+I2-R2","v":0},{"$f":"+J2-S2","v":0},1528292,1092160]
["GENATL001","OM07-0509 O&M2","TermoColon O&M","101150",2500000,2131659,2500000,{"$f":"2155268-23609","v":2131659},0,383065,2116935,{"$f":"+G3-H3","v":368341},1575000,{"$f":"+G3-X3","v":368341},{"$f":"+H3-Y3","v":2131659},{"$f":"+H3/F3","v":1},{"$f":"+G3/E3","v":1},{"$f":"IF(K3>G3,K3-G3,0)","v":0},{"$f":"IF(G3>K3,G3-K3,0)","v":383065},{"$f":"+P3-Q3","v":0},{"$f":"+I3-R3","v":0},{"$f":"+J3-S3","v":0},2500000,{"$f":"2155268-23609","v":2131659}]
["INOTEC001","110-3353 REV 3","Operations & Maintenance","101220",2200782,1955944,0,0,0,0,0,{"$f":"+G4-H4","v":0},0,{"$f":"+G4-W4","v":0},{"$f":"+H4-X4","v":0},{"$f":"+H4/F4","v":0},{"$f":"+G4/E4","v":0},{"$f":"IF(K4>G4,K4-G4,0)","v":0},{"$f":"IF(G4>K4,G4-K4,0)","v":0},{"$f":"+P4-Q4","v":0},{"$f":"+I4-R4","v":0},{"$f":"+J4-S4","v":0},0,0]
["GENATL001","OM07-0509 MOBSC2","TermoColon Mobilization","101150",1500000,1259219,1117674,938265,382326,0,1500000,{"$f":"+G5-H5","v":179409},1026013.7,{"$f":"+G5-X5","v":187021},{"$f":"+H5-Y5","v":938265},{"$f":"+H5/F5","v":0.74511661593416234},{"$f":"+G5/E5","v":0.745116},{"$f":"IF(K5>G5,K5-G5,0)","v":382326},{"$f":"IF(G5>K5,G5-K5,0)","v":0},{"$f":"+P5-Q5","v":6.159341623401815E-7},{"$f":"+I5-R5","v":0},{"$f":"+J5-S5","v":0},1108607,930653]
["EMGASUD001","OM08-1239 O&M-P","Parana O&M","101170",1232946,1051681,825510,704145,556736,0,1382246,{"$f":"+G6-H6","v":121365},1211665,{"$f":"+G6-X6","v":201759},{"$f":"+H6-Y6","v":704145},{"$f":"+H6/F6","v":0.66954238024648161},{"$f":"+G6/E6","v":0.66954270503331048},{"$f":"IF(K6>G6,K6-G6,0)","v":556736},{"$f":"IF(G6>K6,G6-K6,0)","v":0},{"$f":"+P6-Q6","v":-3.2478682887582266E-7},{"$f":"+I6-R6","v":0},{"$f":"+J6-S6","v":0},731259,623751]
["INOTEC001","110-3353 INV","Inventory Costs","101220",1110121.47,1200000,0,0,0,0,0,{"$f":"+G7-H7","v":0},0,{"$f":"+G7-W7","v":0},{"$f":"+H7-X7","v":0},{"$f":"+H7/F7","v":0},{"$f":"+G7/E7","v":0},{"$f":"IF(K7>G7,K7-G7,0)","v":0},{"$f":"IF(G7>K7,G7-K7,0)","v":0},{"$f":"+P7-Q7","v":0},{"$f":"+I7-R7","v":0},{"$f":"+J7-S7","v":0},0,0]
["GENATL001","OM07-0509 RS","Repair Services - TermoColon","101150",1081063.8700000001,982181.16,722583.09,656489.89,267935.09000000003,0,{"$f":"1081017.68-90499.5","v":990518.17999999993},{"$f":"+G8-H8","v":66093.199999999953},0,{"$f":"+G8-W8","v":26909.729999999981},{"$f":"+H8-X8","v":24412.380000000005},{"$f":"+H8/F8","v":0.66840000270418543},{"$f":"+G8/E8","v":0.66839999934508942},{"$f":"IF(K8>G8,K8-G8,0)","v":267935.08999999997},{"$f":"IF(G8>K8,G8-K8,0)","v":0},{"$f":"+P8-Q8","v":3.3590960013540894E-9},{"$f":"+I8-R8","v":0},{"$f":"+J8-S8","v":0},695673.36,632077.51]
["GENATL001","OM07-0509 SP-CC","Spares - Combined Cycle","101150",1000000,856071,464000,397243.72,536000,0,1000000,{"$f":"+G9-H9","v":66756.280000000028},0,{"$f":"+G9-W9","v":4200},{"$f":"+H9-X9","v":3613.1499999999651},{"$f":"+H9/F9","v":0.46403127777952996},{"$f":"+G9/E9","v":0.46400000000000002},{"$f":"IF(K9>G9,K9-G9,0)","v":536000},{"$f":"IF(G9>K9,G9-K9,0)","v":0},{"$f":"+P9-Q9","v":3.1277779529936822E-5},{"$f":"+I9-R9","v":0},{"$f":"+J9-S9","v":0},459800,393630.57]
["EMGASUD001","OM08-1239 RS-M1","Emgasud Matheu Repair Ser Fee","101160",843588.11,707953,0,0,{"$f":"292318.11+56250","v":348568.11},0,{"$f":"367318.11-18750","v":348568.11},{"$f":"+G10-H10","v":0},251250,{"$f":"+G10-W10","v":0},{"$f":"+H10-X10","v":0},{"$f":"+H10/F10","v":0},{"$f":"+G10/E10","v":0},{"$f":"IF(K10>G10,K10-G10,0)","v":348568.11},{"$f":"IF(G10>K10,G10-K10,0)","v":0},{"$f":"+P10-Q10","v":0},{"$f":"+I10-R10","v":0},{"$f":"+J10-S10","v":0},0,0]
["GENATL001","OM07-0509 SP-SC","Spares - Simple Cycle","101150",500000,507566.27,498800,506348.11,1200,0,500000,{"$f":"+G11-H11","v":-7548.109999999986},500000,{"$f":"+G11-W11","v":0},{"$f":"+H11-X11","v":25.429999999993015},{"$f":"+H11/F11","v":0.99759999812438283},{"$f":"+G11/E11","v":0.99760000000000004},{"$f":"IF(K11>G11,K11-G11,0)","v":1200},{"$f":"IF(G11>K11,G11-K11,0)","v":0},{"$f":"+P11-Q11","v":-1.8756172170952823E-9},{"$f":"+I11-R11","v":0},{"$f":"+J11-S11","v":0},498800,506322.68]
["PROEPC001","109-2317 ININV","Naudero Initial Inventory Part","101200",300000,272727.27,8340,7581.82,{"$f":"300000-8340","v":291660},0,{"$f":"300000","v":300000},{"$f":"+G12-H12","v":758.18000000000029},300000,{"$f":"+G12-W12","v":8340},{"$f":"+H12-X12","v":7581.82},{"$f":"+H12/F12","v":2.7800006944666732E-2},{"$f":"+G12/E12","v":2.7799999999999998E-2},{"$f":"IF(K12>G12,K12-G12,0)","v":291660},{"$f":"IF(G12>K12,G12-K12,0)","v":0},{"$f":"+P12-Q12","v":6.9446667340378188E-9},{"$f":"+I12-R12","v":0},{"$f":"+J12-S12","v":0},0,0]
["EMGASUD001","OM08-1239 RS-P1","Emgasud Parana Repair Ser Fee","101170",238832.5,244953.4,0,0,{"$f":"163832.5+56250","v":220082.5},0,{"$f":"238832.5-18750","v":220082.5},{"$f":"+G13-H13","v":0},106250,{"$f":"+G13-W13","v":0},{"$f":"+H13-X13","v":0},{"$f":"+H13/F13","v":0},{"$f":"+G13/E13","v":0},{"$f":"IF(K13>G13,K13-G13,0)","v":220082.5},{"$f":"IF(G13>K13,G13-K13,0)","v":0},{"$f":"+P13-Q13","v":0},{"$f":"+I13-R13","v":0},{"$f":"+J13-S13","v":0},0,0]
["ISOLUX001","109-2785 BMOB","Batanga Mobilization","101210",161000,116000,126562.1,90905.51,34437.9,0,161000,{"$f":"+G14-H14","v":35656.590000000011},0,{"$f":"+G14-W14","v":386.40000000000873},{"$f":"+H14-X14","v":0},{"$f":"+H14/F14","v":0.78366818965517238},{"$f":"+G14/E14","v":0.78610000000000002},{"$f":"IF(K14>G14,K14-G14,0)","v":34437.899999999994},{"$f":"IF(G14>K14,G14-K14,0)","v":0},{"$f":"+P14-Q14","v":-2.4318103448276451E-3},{"$f":"+I14-R14","v":0},{"$f":"+J14-S14","v":0},126175.7,90905.51]
[]
[null,null,"Total Revenue Recognition",null,{"$f":"SUM(E2:E15)","v":15185030.949999999},{"$f":"SUM(F2:F15)","v":13084457.109999999},7902849.1899999995,6604184.0499999998,3031532.5999999996,383065,10551316.789999999,1298665.1400000001,6866586.7000000002,1344177.13,4981247.78]

{"sheet":"PS PES","index":7,"n_rows":4,"n_cols":25,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Signed","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received To-Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["CONSTRUCTION001","210-3148","Field Engineer","No","100001",49489,23930.46,49489,23930.46,0,0,49489,{"$f":"+H2-I2","v":25558.54},49489,{"$f":"+H2-X2","v":0},{"$f":"+I2-Y2","v":1330.3400000000001},{"$f":"+I2/G2","v":1},{"$f":"+H2/F2","v":1},{"$f":"IF(L2>H2,L2-H2,0)","v":0},{"$f":"IF(H2>L2,H2-L2,0)","v":0},{"$f":"+Q2-R2","v":0},{"$f":"+J2-S2","v":0},{"$f":"+K2-T2","v":0},49489,22600.12]
[]
[null,null,"Professional Services Revenue Recognition",null,null,{"$f":"SUM(F2:F3)","v":49489},23930.46,49489,23930.46,0,0,49489,25558.54,49489,0,1330.3400000000001]

{"sheet":"PRS ","index":8,"n_rows":5,"n_cols":25,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Signed","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received To-Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["PUBLICPOWER001","609-2908","Coal Dumper Bldg Modifications","Yes","100001",394846,321036.44,394846,225128.4,0,0,394846,{"$f":"+H2-I2","v":169717.6},394846,{"$f":"+H2-X2","v":0},{"$f":"+I2-Y2","v":134.25999999998021},{"$f":"+I2/G2","v":0.70125497279997251},{"$f":"+H2/F2","v":1},{"$f":"IF(L2>H2,L2-H2,0)","v":0},{"$f":"IF(H2>L2,H2-L2,0)","v":0},{"$f":"+Q2-R2","v":-0.29874502720002749},{"$f":"+J2-S2","v":0},{"$f":"+K2-T2","v":0},394846,224994.14]
["HASTING001","610-3220","Steam Seal Modification","No","100001",91468,68203.070000000007,91468,57816.63,0,0,91468,{"$f":"+H3-I3","v":33651.370000000003},88723.96,{"$f":"+H3-X3","v":0},{"$f":"+I3-Y3","v":106.57999999999447},{"$f":"+I3/G3","v":0.84771301350511041},{"$f":"+H3/F3","v":1},{"$f":"IF(L3>H3,L3-H3,0)","v":0},{"$f":"IF(H3>L3,H3-L3,0)","v":0},{"$f":"+Q3-R3","v":-0.15228698649488959},{"$f":"+J3-S3","v":0},{"$f":"+K3-T3","v":0},91468,57710.05]
[]
[null,null,"Process Services Revenue Recognition",null,null,{"$f":"SUM(F2:F4)","v":486314},389239.51,486314,282945.02999999997,0,0,486314,203368.97,483569.96,0,240.83999999997468]

{"sheet":"FS CON Rev Rec","index":9,"n_rows":5,"n_cols":24,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received To-Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["MWALLSTAR001","410-3370","Sprinkler System Bldg 4076","304014",15293,10705,0,0,0,0,0,{"$f":"+G2-H2","v":0},0,{"$f":"+G2-W2","v":0},{"$f":"+H2-X2","v":0},{"$f":"+H2/F2","v":0},{"$f":"+G2/E2","v":0},{"$f":"IF(K2>G2,K2-G2,0)","v":0},{"$f":"IF(G2>K2,G2-K2,0)","v":0},{"$f":"+P2-Q2","v":0},{"$f":"+I2-R2","v":0},{"$f":"+J2-S2","v":0},0,0]
["MWALLSTAR001","410-3444","Bldg 1117 Fire Protection","304014",12205,9259,1331.57,1009.8,0,1331.57,0,{"$f":"+G3-H3","v":321.77},0,{"$f":"+G3-W3","v":0},{"$f":"+H3-X3","v":0},{"$f":"+H3/F3","v":0.10906145372070418},{"$f":"+G3/E3","v":0.1091003687013519},{"$f":"IF(K3>G3,K3-G3,0)","v":0},{"$f":"IF(G3>K3,G3-K3,0)","v":1331.57},{"$f":"+P3-Q3","v":-3.8914980647716813E-5},{"$f":"+I3-R3","v":0},{"$f":"+J3-S3","v":0},1331.57,1009.8]
[]
[null,"Field Services Revenue Recognition",null,null,{"$f":"SUM(E2:E4)","v":27498},19964,1331.57,1009.8,0,1331.57,0,321.77,0,0,0,null,null,{"$f":"SUM(R2:R4)","v":0},{"$f":"SUM(S2:S4)","v":1331.57},null,{"$f":"SUM(U2:U4)","v":0},{"$f":"SUM(V2:V4)","v":0},{"$f":"SUM(W2:W4)","v":1331.57},{"$f":"SUM(X2:X4)","v":1009.8}]

{"sheet":"FS PES","index":10,"n_rows":45,"n_cols":24,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received To-Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["CALEN000020HWEM","409-2942 REV 1","CI & Alignment Steam Turbine","104002",112092,103385.64,112092,103385.64,0,0,112092,{"$f":"+G2-H2","v":8706.36},12692,{"$f":"+G2-W2","v":0},{"$f":"+H2-X2","v":0},{"$f":"+H2/F2","v":1},{"$f":"+G2/E2","v":1},{"$f":"IF(K2>G2,K2-G2,0)","v":0},{"$f":"IF(G2>K2,G2-K2,0)","v":0},{"$f":"+P2-Q2","v":0},{"$f":"+I2-R2","v":0},{"$f":"+J2-S2","v":0},112092,103385.64]
["CITYO000020CLEM","410-3110","GE 35 MW Steam Turbine Inspec","104002",238626,185432.34,162361.13,126173.44,0,43048.13,119313,36187.69,0,66051.680000000008,51326.47,0.68042845169294641,0.68039999832373677,0,43048.130000000005,2.8453369209646695E-5,0,0,96309.45,74846.97]
["CITYO000020CLEM","410-3110 EW01","Steam Turbine Overhaul","104002",95940,79950,47970,39975,0,47970,0,7995,0,47970,39975,0.5,0.5,0,47970,0,0,0,0,0]
["PACIFICRIM001","FS07-0344JOS-1","Josefa Extra Costs","104002",3000000,3000000,1701500,1206655.33,1298500,0,3000000,494844.66999999993,3000000,-100000,5259.9500000001863,0.40221844333333334,0.56716666666666671,1298500,0,-0.16494822333333337,0,0,1801500,1201395.3799999999]
["VICWLE001","409-2958","Steam Valve Inspection","104002",67055,50374.97,67055,50374.97,0,0,67055,16680.03,67055,0,0,1,1,0,0,0,0,0,67055,50374.97]
["VTPUBPOW001","410-3169 REV 1","P10 Generator No 2 Repair","104002",1420000,1194767.6299999999,1420000,1194767.6299999999,0,0,1420000,225232.37000000011,1420000,0,15784.039999999804,1,1,0,0,0,0,0,1420000,1178983.5900000001]
["OMPA001","409-2227","Steam Turbine Overhaul","104004",1014356.5,790142.16,955523.82,744290.03,58832.68,0,1014356.5,211233.78999999992,954066.5,4260.2899999999208,3337.8100000000559,0.94196977161679363,0.94199999704245985,58832.680000000051,0,-3.022542566621933E-5,0,0,951263.53,740952.22]
["AMERENUE001","410-3218 GOOSE","Borescope Inspections","104005",13212,7582.1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["AMERENUE001","410-3218 KINMUN","Borescope Inspections","104005",6787,3735.9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["AMERENUE001","410-3218 RAC CK","Borescope Inspections","104005",9600,5087.2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["AMERENUE001","410-3314","Gas Leak Repairs","104005",4000,1172.07,4000,1172.07,0,0,4000,2827.9300000000003,4000,0,0,1,1,0,0,0,0,0,4000,1172.07]
["BELGER001","CS10-0212","Load Stator","104005",324.5,117,324.5,117,0,0,324.5,207.5,0,324.5,117,1,1,0,0,0,0,0,0,0]
["COIL001","FS08-1124 REV4","PW Facility Warrensburg, MO","104005",130782,276284.15000000002,130782,276284.15000000002,0,0,130782,-145502.15000000002,117703.8,0,0,1,1,0,0,0,0,0,130782,276284.15000000002]
["DOGEN001","409-2284","Valve Replacement","104005",1482.47,673,1482.47,673,0,0,1482.47,809.47,0,0,0,1,1,0,0,0,0,0,1482.47,673]
["STOVERMILL001","409-2900","Grain Leg Repair","104005",2163,1709.2,136.27000000000001,107.61,0,136.27000000000001,0,28.660000000000011,0,0,0,6.2959279194944998E-2,6.3000462320850673E-2,0,136.27000000000001,-4.1183125905674967E-5,0,0,136.27000000000001,107.61]
["TRISTATE001","410-3219","Exhaust Welding","104005",42825,17394.509999999998,42825,17394.509999999998,0,0,42825,25430.49,42825,0,66.709999999999127,1,1,0,0,0,0,0,42825,17327.8]
["CITYOFSP001","410-3163","Steam Drum Internals Repl","104012",195575.63,145648.17000000001,182902.33,136205.95000000001,12673.3,0,195575.63,46696.379999999976,195575.63,1193.0099999999802,885.72000000000116,0.93517103579124961,0.93520000421320382,12673.300000000017,0,-2.8968421954211898E-5,-1.8189894035458565E-11,0,181709.32,135320.23000000001]
["LG&E001","410-3158","Reaction Tank Rehabilitation","104012",26015,39586.22,26015,39586.22,0,0,26015,-13571.220000000001,26015,0,325,1,1,0,0,0,0,0,26015,39261.22]
["OG&E001","409-2828 REV 2","HRSG Perforated Plates","104012",211200,187603.20000000001,188728.32000000001,167649.01999999999,22471.68,0,211200,21079.300000000017,211200,21.119999999995343,30,0.89363624927506558,0.89360000000000006,22471.679999999993,0,3.6249275065514119E-5,0,0,188707.20000000001,167619.01999999999]
["OMU001","409-2659","Air Heater Basket Replacement","104012",199440,100991.05,199440,100991.05,0,0,199440,98448.95,199440,0,0,1,1,0,0,0,0,0,199440,100991.05]
["WATERL001","410-3461","Air Header Installation","104012",9446,7289.6,7169.51,5532.68,2276.4899999999998,0,9446,1636.83,0,528.97000000000025,408.48000000000047,0.75898266022827043,0.75899957654033456,2276.4899999999998,0,-1.6916312064130246E-5,0,0,6640.54,5124.2]
["CITYSEDALIA001","409-3107","Liberty Park","104013",26475,21118.38,22043.09,17583.990000000002,0,863.09,21180,4459.0999999999985,19062,0,0,0.83263915129853716,0.8326001888574126,0,863.09000000000015,3.8962441124557046E-5,0,0,22043.09,17583.990000000002]
["HAYES001","409-2935","Load Center Cleaning","104013",8730,2144.5,8730,2144.5,0,0,8730,6585.5,8730,0,0,1,1,0,0,0,0,0,8730,2144.5]
["MCCONEX001","409-2732","Traffic Signal Work","104013",26419,23625.47,17193.490000000002,15375.78,0,17193.490000000002,0,1817.7100000000009,0,3241.6200000000008,2900.3700000000008,0.65081371926145803,0.65080018168742204,0,17193.490000000002,1.3537574035993316E-5,0,0,13951.87,12475.41]
["MWALLSTAR001","409-2843 REV 3","WAFB T-9","104013",72318,60404.65,56914.27,47535.33,15403.73,0,72318,9378.9399999999951,0,1366.8099999999977,1136.0600000000049,0.78694819024694296,0.78700005531126405,15403.730000000003,0,-5.1865064321088283E-5,0,0,55547.46,46399.27]
["MWALLSTAR001","409-2844 REV 1","Upgrade Dormitory Campus","104013",45320,39411.14,16981.400000000001,14768.09,0,16981.400000000001,0,2213.3100000000013,0,58.909999999999854,52.8700000000008,0.37471867091385835,0.37469991173874673,0,16981.400000000001,1.8759175111626725E-5,0,0,16922.490000000002,14715.22]
["NATCONTR001","FS08-1678 REV 1","Nat Ctr Aviation - Wichita","104013",5220525,4926101.08,5180332.26,4926101.08,0,390920.07,4789412.1900000004,254231.1799999997,3718649.48,392804.16000000015,392804.16000000015,1,0.99230101570244367,0,390920.06999999937,7.6989842975563327E-3,0,6.4028427004814148E-10,4787528.0999999996,4533296.92]
["SEPTAG001","409-2302","Sedalia Streetscapes","104013",235226.25,304654.42,235226.25,304654.42,0,0,235226.25,-69428.169999999984,235226.25,0,0,1,1,0,0,0,0,0,235226.25,304654.42]
["SEPTAG001","409-2847","Biosolids Composting Facility","104013",46754,40671.129999999997,45468.27,39554.44,0,28007.27,17461,5913.8299999999945,15714.9,18364.979999999996,15977.670000000002,0.97254342330788457,0.97250010694272138,0,28007.269999999997,4.3316365163192927E-5,0,0,27103.29,23576.77]
["STRAUB001","FS08-1708","City of W'burg PDHQ","104013",499901.66,573107.06000000006,499901.66,573107.06000000006,0,0,499901.66,-73205.400000000081,421755.66,0,1868.1600000000326,1,1,0,0,0,0,0,499901.66,571238.9]
["SUNFL001","FS08-1678-1063","Freezer Lighting","104013",625.97,0,625.97,0,0,0,625.97,625.97,0,625.97,0,1,1,0,0,0,0,0,0,0]
["WALDINGER001","409-2951","T9 HVAC WAFB","104013",6212.3,10478.69,6212.3,10478.69,0,0,6212.3,-4266.3900000000003,0,0,2413.2400000000007,{"$f":"+H33/F33","v":1},1,0,0,0,0,0,6212.3,8065.45]
["WALTONCONST001","409-2513 REV 2","Tinker AFB - Warehouse","104013",2074060,1859561.84,92917.89,83391.8,0,92917.89,0,9526.0899999999965,0,12236.960000000006,11097.130000000005,4.4844865175336139E-2,4.4800000964292257E-2,0,92917.89,4.4864211043882385E-5,0,0,80680.929999999993,72294.67]
["AMERENUE001","410-3250 REV 1","Fire Inspection Kinmundy","104014",2600,511.49,2600,511.49,0,0,2600,2088.5100000000002,2600,1914.6399999999999,0,1,1,0,0,0,0,0,685.36,511.49]
["AMERENUE001","410-3251 REV 1","Fire Inspection Raccoon Creek","104014",2890,1605.93,2890,1605.93,0,0,2890,1284.07,2890,614.69999999999982,0,1,1,0,0,0,0,0,2275.3000000000002,1605.93]
["DITZFELD001","409-2714","Backflow Test","104014",3767.4,1708.6,3767.4,1708.6,0,0,3767.4,2058.8000000000002,3767.4,0,0,1,1,0,0,0,0,0,3767.4,1708.6]
["KCPL001","410-3223","Transformer Fire Protection","104014",40905,29692.21,40905,29692.21,0,0,40905,11212.79,40905,355.87000000000262,1491.5400000000009,1,1,0,0,0,0,0,40549.129999999997,28200.67]
["MIDADMERICAN","509-2549 REV 2","Replacement Spot Type Heat","104014",22932,15881.46,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["MWALLSTAR001","409-2764 REV 1","HS 3030 Network Fire Alarm","104014",140000,107597.73,140000,107597.73,0,0,140000,32402.270000000004,126000,0,0,1,1,0,0,0,0,0,140000,107597.73]
["NPPD001","409-2885","Fire Protection Upgrade","104014",2735978,2089047.71,1342544.4,1025166.98,0,330104.59000000003,1012439.81,317377.41999999993,833454.79,191685.91999999993,144025.80999999994,0.49073411540227579,0.49069999831869987,0,330104.58999999985,3.4117083575924134E-5,0,0,1150858.48,881141.17]
["TRISTATE001","410-3375","Fire Protection Audit","104014",21731,4545.18,21731,4545.18,0,0,21731,17185.82,21731,17615.150000000001,1380.17,1,1,0,0,0,0,0,4115.8500000000004,3165.01]
["PACIFICRIM002","FS07-0344CABR-1","Cabrutica Installation","804002",17000000,15300000,2834802.62,1981774.53,7340197.3799999999,0,10175000,853028.09000000008,6475000,-100000,197690.12000000011,0.12952774705882353,0.16675309529411766,7340197.3799999999,0,-3.7225348235294137E-2,0,0,2934802.62,1784084.41]
[]
[null,null,"Field Services Revenue Recognition",null,{"$f":"SUM(E2:E44)","v":35034292.68},31610794.780000001,15822094.620000001,13398633.130000001,8750355.2599999998,968142.2,23604307.68,2423461.4900000002,18176059.41,561235.26,890353.48000000033,null,null,{"$f":"SUM(R2:R44)","v":8750355.2599999998},{"$f":"SUM(S2:S44)","v":968142.19999999925},null,{"$f":"SUM(U2:U44)","v":-1.8189894035458565E-11},{"$f":"SUM(V2:V44)","v":6.4028427004814148E-10},{"$f":"SUM(W2:W44)","v":15260859.359999999},{"$f":"SUM(X2:X44)","v":12508279.649999999}]

{"sheet":"FS PESI Rev Rec","index":11,"n_rows":7,"n_cols":25,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name",null,"Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received To-Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["DERWICK001","409-2956","7EA Liquid Fuel Conversion",null,"104002",0,0,0,0,0,0,0,{"$f":"+H2-I2","v":0},0,{"$f":"+H2-X2","v":0},0,0,0,{"$f":"IF(L2>H2,L2-H2,0)","v":0},{"$f":"IF(H2>L2,H2-L2,0)","v":0},{"$f":"+Q2-R2","v":0},{"$f":"+J2-S2","v":0},0,0,0]
["DERWICK001","409-2956-1","Margarita Island Dual Fuel",null,"104002",11263966,10137569.4,251186.44,225738.73,0,251186.44,0,{"$f":"+H3-I3","v":25447.709999999992},0,157695.52000000002,141374.1,{"$f":"+I3/G3","v":2.2267539791145596E-2},{"$f":"+H3/F3","v":2.2299999840198381E-2},{"$f":"IF(L3>H3,L3-H3,0)","v":0},{"$f":"IF(H3>L3,H3-L3,0)","v":251186.44},{"$f":"+Q3-R3","v":-3.2460049052784185E-5},0,0,93490.92,84364.63]
["GENATL001","ENG08-1127 REV1","Engineering Services",null,"104002",3100000,2630000,2945000,2498500,155000,0,3100000,{"$f":"+H4-I4","v":446500},2945000,0,0,{"$f":"+I4/G4","v":0.95},{"$f":"+H4/F4","v":0.95},{"$f":"IF(L4>H4,L4-H4,0)","v":155000},{"$f":"IF(H4>L4,H4-L4,0)","v":0},{"$f":"+Q4-R4","v":0},0,0,2945000,2498500]
["GENATL001","EQU08-1222","Equip Sales Agreement - CC",null,"104002",37200000,30000000,37200000,30000000,0,0,37200000,{"$f":"+H5-I5","v":7200000},37107637.909999996,0,0,{"$f":"+I5/G5","v":1},{"$f":"+H5/F5","v":1},{"$f":"IF(L5>H5,L5-H5,0)","v":0},{"$f":"IF(H5>L5,H5-L5,0)","v":0},{"$f":"+Q5-R5","v":0},0,0,37200000,30000000]
[]
[null,"Field Services Revenue Recognition",null,null,null,{"$f":"SUM(F2:F6)","v":51563966},42767569.399999999,40396186.439999998,32724238.73,155000,251186.44,40300000,7671947.71,40052637.909999996,157695.52000000002,141374.1,null,null,{"$f":"SUM(S2:S6)","v":155000},{"$f":"SUM(T2:T6)","v":251186.44},null,{"$f":"SUM(V2:V6)","v":0},{"$f":"SUM(W2:W6)","v":0},{"$f":"SUM(X2:X6)","v":40238490.920000002},{"$f":"SUM(Y2:Y6)","v":32582864.629999999}]

{"sheet":"PES TS Rev Rec","index":12,"n_rows":13,"n_cols":24,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received To-Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["TOSHAMER001","2009-05","Technical Training - Whelan","105003",30000,13875,30000,11955.15,0,0,30000,{"$f":"+G2-H2","v":18044.849999999999},30000,{"$f":"+G2-W2","v":0},{"$f":"+H2-X2","v":0},{"$f":"+H2/F2","v":0.86163243243243237},{"$f":"+G2/E2","v":1},{"$f":"IF(K2>G2,K2-G2,0)","v":0},{"$f":"IF(G2>K2,G2-K2,0)","v":0},{"$f":"+P2-Q2","v":-0.13836756756756763},{"$f":"+I2-R2","v":0},{"$f":"+J2-S2","v":0},30000,11955.15]
["TOSHI000020H7EM","2010-01","Tech Training- SW Utilities","105003",18500,13712,18500,7775.29,0,18500,0,10724.71,0,11024.15,2234.59,0.56704273628938151,1,0,18500,-0.43295726371061849,0,0,7475.85,5540.7]
["TOSHI000020H7EM","2010-02","Tech Training - Prairie States","105003",18500,13712,16412.75,7083.05,0,16412.75,0,9329.7000000000007,0,6950,69.199999999999818,0.51655848891481915,0.88717567567567568,0,16412.75,-0.37061718676085653,0,0,9462.75,7013.85]
["TOSHI000020H7EM","2010-03","Tech Training-Belledune","105003",10100,7496.4,10100,11824.74,0,10100,0,-1724.7399999999998,0,0,2740.92,1.5773891467904595,1,0,10100,0.5773891467904595,0,0,10100,9083.82]
["TOSHI000020H7EM","2010-05","Tech Training Prairie States","105003",18500,8019.6,4436.3,1923.2,0,4436.3,0,2513.1000000000004,0,4436.3,1923.2,0.23981245947428798,0.23980000000000001,0,4436.3,1.2459474287962458E-5,0,0,0,0]
["EMERS001","FS08-1251 REV 2","Mark V Engr Lead","105004",106750,73040,106750,161048.59,0,10675,96075,-54298.59,96075,0,0,2.2049368838992334,1,0,10675,1.2049368838992334,0,0,106750,161048.59]
["JOHNCONTBLD001","FS08-1417 CO","WAFB Boiler #2 Repairs","105004",10391,7000,10391,9056.68,0,0,10391,1334.3199999999997,0,0,198.88000000000102,1.2938114285714286,1,0,0,0.29381142857142861,0,0,10391,8857.7999999999993]
["JOHNCONTBLD001","FS08-1422 REV4","Central Heating Contrl Upgrade","105004",862750,614815.46,469594.83,334619.40999999997,0,340182.33,129412.5,134975.42000000004,129412.5,271852.53000000003,193731.92999999996,0.54425991499953497,0.54430000579542159,0,340182.33,-4.0090795886627006E-5,0,0,197742.3,140887.48000000001]
["EPS001","510-3156","ABB Backup Generator Repair","105008",140793.79,116000,88122.83,72600.08,52670.96,0,140793.79,15522.75,140793.79,14781.520000000004,16298.61,0.62586275862068963,0.62589997754872562,52670.960000000006,0,-3.721892803598692E-5,0,0,73341.31,56301.47]
["AMERENUE001","109-2899 MOB","June'10 Ameren Mobilization","105009",26400,23760,26400,43673.4,0,0,26400,-17273.400000000001,26400,4994.880000000001,24409.050000000003,1.8381060606060606,1,0,0,0.83810606060606063,0,0,21405.119999999999,19264.349999999999]
[]
[null,null,"Tech Services Revenue Recognition",null,{"$f":"SUM(E2:E12)","v":1242684.79},{"$f":"SUM(F2:F12)","v":891430.46},{"$f":"SUM(G2:G12)","v":780707.71},{"$f":"SUM(H2:H12)","v":661559.59},{"$f":"SUM(I10:I12)","v":52670.96},{"$f":"SUM(J2:J12)","v":400306.38},433072.29000000004,119148.12000000005,422681.29000000004,314039.38000000006,241606.37999999995]

{"sheet":"PESI TS Rev Rec","index":13,"n_rows":5,"n_cols":25,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Status","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received To-Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["INOTEC001","110-3353 MOB","Angola Mobilization","No","105009",1098394,878715,8128.12,6526.82,0,8128.12,0,{"$f":"+H2-I2","v":1601.3000000000002},0,{"$f":"+H2-X2","v":8128.12},{"$f":"+I2-Y2","v":6526.82},{"$f":"+I2/G2","v":7.4276870202511615E-3},{"$f":"+H2/F2","v":7.4000040058485386E-3},{"$f":"IF(L2>H2,L2-H2,0)","v":0},{"$f":"IF(H2>L2,H2-L2,0)","v":8128.12},{"$f":"+Q2-R2","v":2.7683014402622892E-5},{"$f":"+J2-S2","v":0},{"$f":"+K2-T2","v":0},0,0]
["PROEPC001","109-2317 MOB","Naudero Mobilization","No","105009",900000,765000,620190,527155.26,279810,0,900000,{"$f":"+H3-I3","v":93034.739999999991},877720.12,{"$f":"+H3-X3","v":144630},{"$f":"+I3-Y3","v":122898.5},{"$f":"+I3/G3","v":0.68909184313725491},{"$f":"+H3/F3","v":0.68910000000000005},{"$f":"IF(L3>H3,L3-H3,0)","v":279810},{"$f":"IF(H3>L3,H3-L3,0)","v":0},{"$f":"+Q3-R3","v":-8.1568627451344966E-6},{"$f":"+J3-S3","v":0},{"$f":"+K3-T3","v":0},475560,404256.76]
[]
[null,null,"Tech Services Revenue Recognition",null,null,{"$f":"SUM(F2:F4)","v":1998394},1643715,628318.12,533682.07999999996,279810,8128.12,900000,94636.04,877720.12,152758.12,129425.32]

{"sheet":"PESI O&M Rev Recog","index":14,"n_rows":12,"n_cols":25,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Signed","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received To-Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["GENATL001","OM07-0509 RS","Repair Services - TermoColon",null,"101150",1081063.8700000001,982181.16,722583.09,656489.89,267935.09000000003,0,{"$f":"1081017.68-90499.5","v":990518.17999999993},{"$f":"+H2-I2","v":66093.199999999953},0,{"$f":"+H2-X2","v":26909.729999999981},{"$f":"+I2-Y2","v":24412.380000000005},{"$f":"+I2/G2","v":0.66840000270418543},{"$f":"+H2/F2","v":0.66839999934508942},{"$f":"IF(L2>H2,L2-H2,0)","v":267935.08999999997},{"$f":"IF(H2>L2,H2-L2,0)","v":0},{"$f":"+Q2-R2","v":3.3590960013540894E-9},{"$f":"+J2-S2","v":0},{"$f":"+K2-T2","v":0},695673.36,632077.51]
["GENATL001","OM07-0509 SP-CC","Spares - Combined Cycle",null,"101150",1000000,856071,464000,397243.72,536000,0,1000000,66756.280000000028,0,4200,3613.1499999999651,0.46403127777952996,0.46400000000000002,536000,0,3.1277779529936822E-5,0,0,459800,393630.57]
["GENATL001","OM07-0509 SP-SC","Spares - Simple Cycle",null,"101150",500000,507566.27,498800,506348.11,1200,0,500000,-7548.109999999986,500000,0,25.429999999993015,0.99759999812438283,0.99760000000000004,1200,0,-1.8756172170952823E-9,0,0,498800,506322.68]
["EMGASUD001","OM08-1239 RS-M1","Emgasud Matheu Repair Ser Fee",null,"101160",843588.11,707953,0,0,{"$f":"292318.11+56250","v":348568.11},0,{"$f":"367318.11-18750","v":348568.11},0,251250,0,0,0,0,348568.11,0,0,0,0,0,0]
["EMGASUD001","OM08-1239 RS-P1","Emgasud Parana Repair Ser Fee",null,"101170",238832.5,244953.4,0,0,{"$f":"163832.5+56250","v":220082.5},0,{"$f":"238832.5-18750","v":220082.5},0,106250,0,0,0,0,220082.5,0,0,0,0,0,0]
["PROEPC001","109-2317 ININV","Naudero Initial Inventory Part",null,"101200",300000,272727.27,8340,7581.82,{"$f":"300000-8340","v":291660},0,{"$f":"300000","v":300000},758.18000000000029,300000,8340,7581.82,2.7800006944666732E-2,2.7799999999999998E-2,291660,0,6.9446667340378188E-9,0,0,0,0]
["ISOLUX001","109-2785 BMOB","Batanga Mobilization",null,"101210",161000,116000,126562.1,90905.51,34437.9,0,161000,35656.590000000011,0,386.40000000000873,0,0.78366818965517238,0.78610000000000002,34437.899999999994,0,-2.4318103448276451E-3,0,0,126175.7,90905.51]
["INOTEC001","110-3353 INV","Inventory Costs",null,"101220",1110121.47,1200000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["INOTEC001","110-3353 REV 3","Operations & Maintenance",null,"101220",2200782,1955944,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Total O&M Rev Recognition",null,null,{"$f":"SUM(F2:F11)","v":7435387.9500000002},6843396.0999999996,1820285.19,1658569.0499999998,1699883.6,0,3520168.7899999996,161716.14000000001,1157500,39836.12999999999,35632.779999999962,null,null,{"$f":"SUM(S2:S11)","v":1699883.5999999999},{"$f":"SUM(T2:T11)","v":0},null,{"$f":"SUM(V2:V11)","v":0},{"$f":"SUM(W2:W11)","v":0},{"$f":"SUM(X2:X11)","v":1780449.0599999998},{"$f":"SUM(Y2:Y11)","v":1622936.27}]

{"sheet":"International O&M Rev Recog","index":15,"n_rows":7,"n_cols":25,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Project Number","Project Name","Signed","Department","Project Amount","Forecast Total Cost","Net Recognized Revenue","Actual Total Cost","Actual BIEE Amount 2455","Actual EIEB Amount 1205","Actual Billings","Net Margin","Cash Received To-Date","Current Month Revenue","Current Month Cost","Cost % Completed","Rev % Recognized","Calc BIEE","Calc EIEB","Difference Rev Recog","Difference BIEE","Difference EIEB","Prior Month Net Recognized Revenue","Prior Month Total Cost"]
["GENATL001","OM07-0509 O&M2","TermoColon O&M",null,"101150",2500000,2131659,2500000,{"$f":"2155268-23609","v":2131659},0,383065,2116935,{"$f":"+H2-I2","v":368341},1575000,{"$f":"+H2-Y2","v":368341},2131659,{"$f":"+I2/G2","v":1},{"$f":"+H2/F2","v":1},{"$f":"IF(L2>H2,L2-H2,0)","v":0},{"$f":"IF(H2>L2,H2-L2,0)","v":383065},{"$f":"+Q2-R2","v":0},{"$f":"+J2-S2","v":0},0,2500000,{"$f":"2155268-23609","v":2131659}]
["GENATL001","OM07-0509 MOBSC2","TermoColon Mobilization",null,"101150",1500000,1259219,1117674,938265,382326,0,1500000,{"$f":"+H3-I3","v":179409},1026013.7,187021,938265,{"$f":"+I3/G3","v":0.74511661593416234},{"$f":"+H3/F3","v":0.745116},{"$f":"IF(L3>H3,L3-H3,0)","v":382326},{"$f":"IF(H3>L3,H3-L3,0)","v":0},{"$f":"+Q3-R3","v":6.159341623401815E-7},0,0,1108607,930653]
["EMGASUD001","OM08-1239 O&M-M","Matheu O&M",null,"101160",2516697,1798502.01,1639380,1171546,392587,0,2031967,{"$f":"+H4-I4","v":467834},1896408,547220,1171546,{"$f":"+I4/G4","v":0.65140099565415555},{"$f":"+H4/F4","v":0.65140142019480296},{"$f":"IF(L4>H4,L4-H4,0)","v":392587},{"$f":"IF(H4>L4,H4-L4,0)","v":0},{"$f":"+Q4-R4","v":-4.2454064741459518E-7},0,0,1528292,1092160]
["EMGASUD001","OM08-1239 O&M-P","Parana O&M",null,"101170",1232946,1051681,825510,704145,556736,0,1382246,{"$f":"+H5-I5","v":121365},1211665,201759,704145,{"$f":"+I5/G5","v":0.66954238024648161},{"$f":"+H5/F5","v":0.66954270503331048},{"$f":"IF(L5>H5,L5-H5,0)","v":556736},{"$f":"IF(H5>L5,H5-L5,0)","v":0},{"$f":"+Q5-R5","v":-3.2478682887582266E-7},0,0,731259,623751]
[]
[null,null,"Total International O&M Rev Recognition",null,null,7749643,{"$f":"SUM(G2:G6)","v":6241061.0099999998},6082564,4945615,1331649,383065,7031148,1136949,5709086.7000000002,1304341,4945615,null,null,{"$f":"SUM(S2:S6)","v":1331649},{"$f":"SUM(T2:T6)","v":383065},null,{"$f":"SUM(V2:V6)","v":0},{"$f":"SUM(W2:W6)","v":0},{"$f":"SUM(X2:X6)","v":5868158},{"$f":"SUM(Y2:Y6)","v":4778223}]